Thank you so much for this video. I went back to college in September to study Medical Secretary at 52 years old. Our Excel tutor could NOT get Nested IF Funcion to work, so, she couldn't teach us how to do the Nested IF Function. We had our Christmas exam a few days ago, and there was a few question on Nested If Function, needless to say, NOT ONE of us could answer the question. Your Video has explained it very clearly. Thank you so much.
hey guys, pretty old video, remember this, you can use, SWITCH function which is much easier to write than nested if. it is because you don't have to use if again again.
Nice video... One question... If the marks are exact 40, then it will be considered as less than 40 or greater than 40? Means pass or fail?... Because there is no any option as greater than equal to or less than equal to
Is it possible to convert the values into sentence like if it contains "yes", then "This sentence"... And if the ce contains "no" then "That sentence".. and blank for NA..
Sir I have question. When I use IF formula like this =IF(H15>I15,"(=H12-I12)",0), it shows the formula (=H12-I12) instead of executing this formula. Please guide me what I am missing in this formula.
I have a query , A. B. C. D 1. 2. 3. 4 5. 6. 7. 8 I want minimum of range(R2) & display of column cell of minimum value. Ex :- 1 A I need the formula for the same
Sir, I have a question, regarding my job work, would be really appreciated, if you can make a formula for my work, as I am struggling since long, where I can send my query?
Sir I want a formula to dry ration summary regarding that is last month balance + receive during the month = grant total ( - ) expenditure then = next month balance
Is there any formula in excel where if cell A1 have a value iPhone and cell B1 have iphone then cell C1 should populate ans as same.if cell A1 have a value Smartphone and cell B1 have iphone then cell C1 should populate ans as Downgrade. Please help me with the solution for it. It would be a great help.
use a logical function to find out if each customer is eligible for a daily deal (Y) or not (N), based on. (*Hint - use a nested if function) Monday 20% off total bill Tuesday- Free dessert Wednesday Mains - Buy 1 Get 1 Thursday- 10% off total bill Friday No -deal Saturday -No deal Sunday -Free side order please help on this problem
Respected Sir, I am working in Postal Department, I Have a data based on which I have to calculate commission to employees, Here they prepare manually and submit , Can You Help to Prepare Excel file for calculations of commission.. I will be very Grateful 🙏 I have all the rule and conditions , Percentage rate of commission that can be required for preparation of excel... Please
Sir this is not nested if function... This is called Nested if else function it is also called Multiple If function.... Nested if function is totally different... In nested if else means multiple if "When first condition will false then and then only second condition will be check" but in nested if "when first condition will be true then and then only second condition will be check" this is the difference between "nested if else / Multiple If" and "nested if".... TOTAL 8 Types of if else conditions are there in excel 1) Simple if : classified again in 2 types 2) Multiple or Nested if else : classified in 3 types 3) Nested if : classified in 3 types My english is poor, I am not good in english so if there is any mistake in english I am sorry for that.... Jai Shri Ram
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "RUclips12" to get ‘’FLAT 12%’’ OFF at Checkout.
Can I say something.. you are a very good instructor. So clear and simple!Absolutely brilliant!
No you may not
Simple... what was so hard for me to understand this in class... 🙏🏿 Thank you
Thank you so much for this video. I went back to college in September to study Medical Secretary at 52 years old. Our Excel tutor could NOT get Nested IF Funcion to work, so, she couldn't teach us how to do the Nested IF Function. We had our Christmas exam a few days ago, and there was a few question on Nested If Function, needless to say, NOT ONE of us could answer the question. Your Video has explained it very clearly. Thank you so much.
Wow, learned a lot, thnx ji💓
I'm much confident for tomorrow's exam now
Studying here at noon
Wooow!! Brief and direct to the Point, I really embrace it..... May the LORD! Do you good!
Thank you for simplifying excel functions. You Sir, are a gifted teacher. Blessings.
You did great job brother 👍 you are real content creator you add value to every professional love it man god bless you ....
I rarely comment on videos. Short and to the point. Nice!
Thank you so much for the very clear and easy to understand tutorial of nested if! ❤️
Short and straight-forward, loved it!
hey guys, pretty old video, remember this, you can use, SWITCH function which is much easier to write than nested if. it is because you don't have to use if again again.
You are looking like a shoyab malik sir... Your explanation is very easy method... Simple way 👏👏👏
thank you soooooooo much helped me alot through a simple 3min vedio
Thanks dude because of you I was able to do my practical SEA excel so fast the girls were impressed
Clear teaching, very easy to follow, thanks a lot!
thank you for the simple and helpful tutorial, i like things short and direct
You explained this well. Thank you.
Very clear and easy to learn, thank you.
Awesome.....Keep up good work
Thank you sir this is very helpful for me
Very good Clarification You are awsome Sir
excellent sir..well explained
Nice video... One question... If the marks are exact 40, then it will be considered as less than 40 or greater than 40? Means pass or fail?... Because there is no any option as greater than equal to or less than equal to
also want to know
It would be greater than or equal to.
Amazing.. Short and clear🥳
Oh my Lord, thank you so much!
Thank you so much you are like real guide for us
Nice teacher but try and zoom in so that we can see it boldly when using our phones🙏💯
Thank you very much nice teaching brother
Thank you sir ...helped me alot
Excellent sir
very well explained
Thanks, very good tutorial
Nyccc sir, Thanks
Is it possible to convert the values into sentence like if it contains "yes", then "This sentence"... And if the ce contains "no" then "That sentence".. and blank for NA..
kindly add a video with multiple if functions into the If functions
(Nested if)
This is nested IFs
Sir I have question.
When I use IF formula like this =IF(H15>I15,"(=H12-I12)",0), it shows the formula (=H12-I12) instead of executing this formula.
Please guide me what I am missing in this formula.
Very good indeed, brother!
U R Excellent
Not gonna lie i was lokking for this
Can I Use = inside if logical attribute like If 45=45
Please enlighten us how do you keep a big touch screen behind you ?
Thanks in advance
YES ! I am also wondering
@RITIK RAJ N
Thanks, any good link you can suggest for learning this...
Easy to understand...Thank you so much🙏
Great..💛
Thank you so much !
Excellent
I have a query ,
A. B. C. D
1. 2. 3. 4
5. 6. 7. 8
I want minimum of range(R2) & display of column cell of minimum value.
Ex :- 1 A
I need the formula for the same
Thank you sir 😊
nice content
please add the practice file that could be more helpful for excel learner
very good video
THANK YOU SO MUCH SIR
Sir, I have a question, regarding my job work, would be really appreciated, if you can make a formula for my work, as I am struggling since long, where I can send my query?
Thank you so much
NICE
thanks sir a lot!
I am a different race, but this guy is absolutely charming looking!
What about when I have a question like this "if a student has final mark between 50 and 74, display pass"???
Thanks a lot Sir
Bohat Bohat shukria.
Very good
please give example of Tax liabilty calculation - as per tax slab
Thank you sir
Agar vaha koi -ve value hoti to ham condition kese apply krte for some another scenarios
Hello please give examples for nested if with v lookup for multiple search value
Sir I want a formula to dry ration summary regarding that is last month balance + receive during the month = grant total ( - ) expenditure then = next month balance
good video
There seems to be some issue with my Excel as when I am entering Distinction in inverted commas, it shows wrong formulae. Can anyone help ??
Shukriya👍
Great
I have entered same formula perfectly ..even though it is showing ..that there is an error in the formula
Could u plzz help me for this
@@deepag6493 Hi Deepa,
For support in MS Excel, please contact Me on goodnessshallprevail@gmail.com.
Thank You!
Is there any formula in excel where if cell A1 have a value iPhone and cell B1 have iphone then cell C1 should populate ans as same.if cell A1 have a value Smartphone and cell B1 have iphone then cell C1 should populate ans as Downgrade.
Please help me with the solution for it. It would be a great help.
thank you
use a logical function to find out if each customer is eligible for a daily deal (Y) or not (N), based on. (*Hint - use a nested if function)
Monday 20% off total bill
Tuesday- Free dessert
Wednesday Mains - Buy 1 Get 1
Thursday- 10% off total bill
Friday No -deal
Saturday -No deal
Sunday -Free side order
please help on this problem
Really Thanks
sir i need help in my excel
how to seek?
Respected Sir,
I am working in Postal Department, I Have a data based on which I have to calculate commission to employees,
Here they prepare manually and submit , Can You Help to Prepare Excel file for calculations of commission..
I will be very Grateful 🙏
I have all the rule and conditions , Percentage rate of commission that can be required for preparation of excel...
Please
Please do so that we can see the formula it's not visible. Dikh nahi raha.
good explain
U must try in films.....handsome
Sir what if the number is exactly 60? What will be the result according to excel?
PASS
Sir, If marks are 40 then it shows FALSE !
When I drag down its not coming
Sir l have a question
than u so mch
Thanks
Nice
units k matter me b bataye
ex. 0 to 24 unit = nill
25 to 35 unit = 50
36 to 47 unit =70
48 to 59 unit = 90
60 and above =110
Can you help me with my sheet?
Hi Vishal,
For support in MS Excel, please contact Me on goodnessshallprevail@gmail.com.
Thank You!
so nice
Can you please share the excel file of all video?
SUPER
Sir aapki ye excel ki class english me thi to hindi me bhi asi class aapki oy language
pro teacher
Sir this is not nested if function... This is called Nested if else function it is also called Multiple If function.... Nested if function is totally different... In nested if else means multiple if "When first condition will false then and then only second condition will be check" but in nested if "when first condition will be true then and then only second condition will be check" this is the difference between "nested if else / Multiple If" and "nested if"....
TOTAL 8 Types of if else conditions are there in excel
1) Simple if : classified again in 2 types
2) Multiple or Nested if else : classified in 3 types
3) Nested if : classified in 3 types
My english is poor, I am not good in english so if there is any mistake in english I am sorry for that....
Jai Shri Ram
thnku so much
Just prepare the sheet by yourself It will hardly take 5 min to practise instead of asking everything
Thanks sir
I need an excel expert, who can help me pls