This is really good, In every view every one discuss only one formula but u clear my concept with the multiple formula in Thank you so much, I appreciate
Sir me ne if or and ka formula use kerky category 1, 2, 3 , 4 nikaly hain jo behteen kam ker reha he, lekin us formula men conditional formula ki madad se men category 1 ko green category 2 ko yelow, category 3 ko pink or category 4 ko red karna chahta jo nhi horeha kindly guide me ?
The formula for 4th question, if we want to add the same complete formula with one more criteria, How to add, l mean, bracket close then we add or comma will work.
Thanks. The link is given in the video description from where you can download the excel files. You can get all the files from this Link - www.mdatafinnovatics.com/youtubevideoattachments/.
If I have some values in one column 0.0, 0.81, 1.25, 2.50, 3.50 but we want print to other column 0 to 0.5 through if condition so plz suggest formula sir ji or any guys
Studypoint, I am not getting your condition. Aap detail me apni condition ko bataiye ya fir agar aapke pass koi excel file hai jisme ye condition hai to usko aap email kar sakte ho support@mdatafinnovatics.com par with complete detail. We will solve and revert you back. Thank You!!
Sir agar hum chart banate he row me company name and column me item ke rate Aur agar hame ye dusare sheet me ye result chahiye ki is company ko ye item diya he to uska rate vaha ana chahiye To kaise kare sir
Amit, you have to show the data in Excel only then we can help you. Anyways you can use COUNTIF formula if you want to check whether the student is absent in any of the exam or in a particular exam.
@@MDataFinnovatics suppose a student (out of 6 subject) had appeared in 5 subject and absent in 1 subject,and that point we write ABS for that particular subject then how can we count total of all 6 subject ,it is giving error becoz we have write ABS in place of number.
@Amit, No need to use ABS formula as ABS formula converts the negative numbers to positive. Through COUNTIF formula you can check how many times that particular student is appearing. If the formula gives you 5 it means he was absent in 1 exam, if it gives 4 it means he was absent in 2 exams because there are total 6 subjects in total which I am assuming.
Excellent 👍 Sir, attandance sheet me Saturday "A" hone per Sunday bhi "Leave" count ho jaye aur Monday "A" hone per Sunday bhi "Leave" count ho jaye aur Saturday or Monday "A" hone par 3 din Leave count ho jaye aesa formula bataiye.
how to Calculate the PR to PO duration based on the followings: If LOA date is available ignore the PO date and calculate the Cycle time from LOA date less RFQ Date (if RFQ date is missing consider the PR Approval Date) Waiting your reply.
Hallo, im working on an excel sheet that has a column named Overall results. Under this column I have used average function to find the average of each students score(=AVERAGE(F5,J5,K5,L5,O5,P5,Q5) ). My desired outcome is to display conditions "Pass" "Fail" "Refer" on the same column of the Overall performance. I have tried this formular =AVERAGE(F5,J5,K5,L5,O5,P5,Q5) + IF(R34>=85,"DISTINCTION(1)",IF(R34>=76,"DISTINCTION(2)",IF(R34>=68,"CREDIT (3)",IF(R34>=60,"CREDIT (4)",IF(R34>=50,"PASS (5)",IF(R34>=40,"PASS (6)", "REFERRAL")))))). The idea is the AVERAGE function calculates the average of the specified cells, and the IF function checks the value in cell R5(which is the Overall Performance column) and returns the corresponding text label, within the same cell. is this calculation possible??
@@MDataFinnovatics Hi, found another way around it. here is how: =IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=84.5,"Distinction (1)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=75.5,"Distinction (2)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=67.5,"Credit (3)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=59.5,"Credit (4)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=49.5,"Pass (5)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=39.5,"Pass (6)","Referral (7)"))))))
Sir , 01) In-patient = private hospital = form D 02) In-patient = recognized hospital = form B 03) Out-patient = recognized hospital = form D ye tino conditions if formula mein kaise dall sakte hai . Pls guide
Rakesh, you need to use IF & AND formula together to solve your query! If need more clarity on the formula, please share your excel file with detailed query on support@mdatafinnovatics.com
Call us at +91-9354674901 for
Advanced Excel LIVE Training,
Excel Automation, Excel Dashboards, and Power BI assistance. 😀😀👍
Hi
I want logical function class please
Hi
Dashboard and power BI
This is really good,
In every view every one discuss only one formula but u clear my concept with the multiple formula in
Thank you so much, I appreciate
very good sir
sir aapka shikhane ka tarika bahot achha he, bahot bariki se sikhate he,
thank you sir
Thank you Raj Patel for your positive feedback!
Good examples and great Video
great way to make understand is the best part of video thanks.
Thank you Live Love!
Thanks for this video
Very useful..❤
Your welcome Vijay!!
Sir thank you very much. you can solve my big problem with this video.Thank You.
Your welcome Ayaz Laliwala. Share and subscribe Mdata Finnovatics channel for more amazing and knowledgeable videos!!
Very interesting. Thanks for guidance
Santosh - your welcome and thanks for liking the videos. 👍
Sir aapke sabhi video SUPER h
Thanks, saurabh!
You are really great. Thank you very much.
Very nice video.. clarify most of the doubts. thanks you
Thanks. Please share the video with your friends and subscribe the channel for more interesting videos.
Bahut acha laga,
very helpful
This is solid Video
like it. 👍
Thanks Debclavtech!!
Outstanding sir
telephone Bill calculat k liy kon sa formula use ho ga
how we can color the row by if formula
Excellent Sir👍👌
Thank you Swade alhade cooking!
Could you please share the practice file?
Best examples with multiple formula
Thank you for your appreciation!
Thank you so much sir
Really great sir thaka a lot
Thank you, Desi Recipes!
Sir nested if functions me logical test me sab numbers use karte hai samzane ke liye, but uske jagah words use kaise karte hai??
Words can be used in the same manner as numbers. I'll try to make a video about this reasoning.
Very good information and well explained. Thank you!
Thank you Charan Salve. Don't forget to share and subscribe the channel!!
Content ❤
Good 👍
Thanks Vijay!
How to use nested if with and function
You will get a video on this topic very soon!
This is the video on Nested IF with AND function. ruclips.net/video/Ng3rcSKWV4E/видео.html
Very clear funda
Thank you!
very nice learning
Nasemuddin, Thank you! 😃
I have one problems. I create my excel file in which Total are different and when I wanna grade of it that time face problems
Hi Upendra, Please share your problem at support@mdatafinnovatics.com with your excel file.
Well explained
Thank you, Premjith KM
it was great i love it
Excellent sir ji
Thanks and welcome
Thank you bhaiya
Sir me ne if or and ka formula use kerky category 1, 2, 3 , 4 nikaly hain jo behteen kam ker reha he, lekin us formula men conditional formula ki madad se men category 1 ko green category 2 ko yelow, category 3 ko pink or category 4 ko red karna chahta jo nhi horeha kindly guide me ?
R u very good teacher
Thank you!
Very nice.
Good.
Weldon bro owesome
Thank you Rohit Kumar!
The formula for 4th question, if we want to add the same complete formula with one more criteria, How to add, l mean, bracket close then we add or comma will work.
Fabulous bro
Thanks Arsh Acadmy!
Sir... And aur or me jab if ka use karte hai to sirf Yes or No ko validate karne k liye use karte hai kya...??????
Tysm sir
Very Good Vdo
Thank you Waseemraja!
KAI HOURS KI SEARCHING KE BAAD AAPKI VIDEO SE SOLUTION MILA. THANKS
Learning Tube, Thank you for your positive comments.
Very nice way of explaining 👍
Thank you so much 🙂. Please like the video and share with your friends.
nice. please always put the file in each excel video
Thanks. The link is given in the video description from where you can download the excel files. You can get all the files from this Link - www.mdatafinnovatics.com/youtubevideoattachments/.
Sir, How I can delete all special characters from my excel in a single excel formula. pls, help.....
Hi Surbir. Please refer this video - ruclips.net/video/4POO7Y1GlIw/видео.html
How can we calculate commission with given weightage
fantastic
Thank you Brajasundar!!
great sir g
Thanks..!
Sir u are doing a great job 👍...gonna contact you soon
Thank you Sir!!
If I have some values in one column 0.0, 0.81, 1.25, 2.50, 3.50 but we want print to other column 0 to 0.5 through if condition so plz suggest formula sir ji or any guys
Studypoint, I am not getting your condition. Aap detail me apni condition ko bataiye ya fir agar aapke pass koi excel file hai jisme ye condition hai to usko aap email kar sakte ho support@mdatafinnovatics.com par with complete detail. We will solve and revert you back. Thank You!!
Excellent
Thanks 🙂
Sir can we apply multiple if on this question along with "and" and "or"
I have to calculate price of different vehicles based on used and new
Sir agar hum chart banate he row me company name and column me item ke rate
Aur agar hame ye dusare sheet me ye result chahiye ki is company ko ye item diya he to uska rate vaha ana chahiye
To kaise kare sir
How to use if function when any student is absent in all exam or particular subject.
Amit, you have to show the data in Excel only then we can help you. Anyways you can use COUNTIF formula if you want to check whether the student is absent in any of the exam or in a particular exam.
@@MDataFinnovatics suppose a student (out of 6 subject) had appeared in 5 subject and absent in 1 subject,and that point we write ABS for that particular subject then how can we count total of all 6 subject ,it is giving error becoz we have write ABS in place of number.
@Amit, No need to use ABS formula as ABS formula converts the negative numbers to positive. Through COUNTIF formula you can check how many times that particular student is appearing. If the formula gives you 5 it means he was absent in 1 exam, if it gives 4 it means he was absent in 2 exams because there are total 6 subjects in total which I am assuming.
@@MDataFinnovatics i meant absent for ABS not formula.
anyway how can i share my excel sheet in which i have particular doubt.
You can email us at support@mdatafinnovatics.com with complete query.
Sir I want learn from beginning Excel by online only Friday class
Imran, please visit the below link for the training
mdatafinnovatics.com/live-advanced-excel-training/
Excellent 👍
Sir, attandance sheet me Saturday "A" hone per Sunday bhi "Leave" count ho jaye aur Monday "A" hone per Sunday bhi "Leave" count ho jaye aur Saturday or Monday "A" hone par 3 din Leave count ho jaye aesa formula bataiye.
You can use *"Nested if"* , *"OR"* formula together based on the scenario.
I am from Faridabad
Your welcome Tarun!
We have need some help in excel formula through mail..please tell me would paid money or not.
And also said How many paid
how to Calculate the PR to PO duration based on the followings:
If LOA date is available ignore the PO date and calculate the Cycle time from LOA date less RFQ Date (if RFQ date is missing consider the PR Approval Date)
Waiting your reply.
Sir, we have solved your query and reverted you back on the email.
Sir Stock Buy karne par add ho jaye sell karne par minus ho jaye uske liye kya formula rahega
You can use the IF condition on Buy and Sell. With Buy you can add and with Sell you can substract the values.
@@MDataFinnovaticsSir, please share formula
You have to share the data first in Excel, then we can help you with the formula.
Fourmula to achcha hain but isko or easy kar do to jada achcha ho
Sure Suyash. We will try to make the formulas more simpler!
Hallo, im working on an excel sheet that has a column named Overall results. Under this column I have used average function to find the average of each students score(=AVERAGE(F5,J5,K5,L5,O5,P5,Q5) ). My desired outcome is to display conditions "Pass" "Fail" "Refer" on the same column of the Overall performance. I have tried this formular =AVERAGE(F5,J5,K5,L5,O5,P5,Q5) + IF(R34>=85,"DISTINCTION(1)",IF(R34>=76,"DISTINCTION(2)",IF(R34>=68,"CREDIT (3)",IF(R34>=60,"CREDIT (4)",IF(R34>=50,"PASS (5)",IF(R34>=40,"PASS (6)", "REFERRAL")))))).
The idea is the AVERAGE function calculates the average of the specified cells, and the IF function checks the value in cell R5(which is the Overall Performance column) and returns the corresponding text label, within the same cell.
is this calculation possible??
Komplit Random, please try to replace the R34 cell with the Average formula.
@@MDataFinnovatics Hi, found another way around it. here is how: =IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=84.5,"Distinction (1)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=75.5,"Distinction (2)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=67.5,"Credit (3)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=59.5,"Credit (4)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=49.5,"Pass (5)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=39.5,"Pass (6)","Referral (7)"))))))
You got the solution. That is amazing!
कुछ ज़्यादा ही advance हो गया था !!
👍
Write 'eli for gift, in front of females having salary less then 50000, if not Write 'not eligible for gift'
Are u cmplt assignment mam plz reply
Only give two double cots
@@mayurpardhi261 No
Can u help me
And ka 20 example , or ka 20 example, and ka 20 example dejia na please , please, please sir.
Very soon, I will create a video with more complex conditions.
tIs there anyone here to help me complete my assignment?
One excel file sent on your mail
We have shared the file with you over email. Please check
Sir ,
01) In-patient = private hospital = form D
02) In-patient = recognized hospital = form B
03) Out-patient = recognized hospital = form D
ye tino conditions if formula mein kaise dall sakte hai . Pls guide
Rakesh, you need to use IF & AND formula together to solve your query!
If need more clarity on the formula, please share your excel file with detailed query on support@mdatafinnovatics.com
app etna fast explain kerte ho kuch samjh nahi aaya