To Get Certification, Click Here: bit.ly/38Jyu3p Use coupon "KZfaq12" to get ‘’FLAT 12%’’ OFF at Checkout.

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.

Simple... what was so hard for me to understand this in class... 🙏🏿 Thank you

Wooow!! Brief and direct to the Point, I really embrace it..... May the LORD! Do you good!

Can I say something.. you are a very good instructor. So clear and simple!Absolutely brilliant!

Thank you for simplifying excel functions. You Sir, are a gifted teacher. Blessings.

I rarely comment on videos. Short and to the point. Nice!

Clear teaching, very easy to follow, thanks a lot!

Thank you so much for the very clear and easy to understand tutorial of nested if! ❤️

You did great job brother 👍 you are real content creator you add value to every professional love it man god bless you ....

Very clear and easy to learn, thank you.

thank you soooooooo much helped me alot through a simple 3min vedio

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.

Thanks dude because of you I was able to do my practical SEA excel so fast the girls were impressed

Short and straight-forward, loved it!

You explained this well. Thank you.

Amazing.. Short and clear🥳

You are looking like a shoyab malik sir... Your explanation is very easy method... Simple way 👏👏👏

thank you for the simple and helpful tutorial, i like things short and direct

Very good Clarification You are awsome Sir

Very good indeed, brother!

Thanks, very good tutorial

Thank you so much you are like real guide for us

Oh my Lord, thank you so much!

Awesome.....Keep up good work

Thank you sir ...helped me alot

excellent sir..well explained

Thank you very much nice teaching brother

Thank you sir this is very helpful for me

Great..💛

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..

Excellent sir

U R Excellent

Excellent

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?

very well explained

Bohat Bohat shukria.

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

thanks sir a lot!

Thank you sir 😊

Really Thanks

What about when I have a question like this "if a student has final mark between 50 and 74, display pass"???

very good video

Thanks a lot Sir

THANK YOU SO MUCH SIR

NICE

Shukriya👍

Thank you so much

Very good

Great

nice content

good video

Nice teacher but try and zoom in so that we can see it boldly when using our phones🙏💯

Nyccc sir, Thanks

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.

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

Thanks sir

so nice

Not gonna lie i was lokking for this

thank you

please add the practice file that could be more helpful for excel learner

SUPER

Agar vaha koi -ve value hoti to ham condition kese apply krte for some another scenarios

good explain

kindly add a video with multiple if functions into the If functions (Nested if)

Nice

pro teacher

thnku so much

please give example of Tax liabilty calculation - as per tax slab

Hello please give examples for nested if with v lookup for multiple search value

Thanks

than u so mch

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

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 ??

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

Please enlighten us how do you keep a big touch screen behind you ? Thanks in advance

Can I Use = inside if logical attribute like If 45=45

I am a different race, but this guy is absolutely charming looking!

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.

U must try in films.....handsome

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 what if the number is exactly 60? What will be the result according to excel?

Can you please share the excel file of all video?

Sir aapki ye excel ki class english me thi to hindi me bhi asi class aapki oy language

Indian guy to the clutch

When I drag down its not coming

Easy to understand...Thank you so much🙏

sir i need help in my excel how to seek?

sir plz formulas bhi btaye

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

I have entered same formula perfectly ..even though it is showing ..that there is an error in the formula

Sir l have a question

Can you help me with my sheet?

Sir, If marks are 40 then it shows FALSE !

Please do so that we can see the formula it's not visible. Dikh nahi raha.

I need an excel expert, who can help me pls

Just prepare the sheet by yourself It will hardly take 5 min to practise instead of asking everything

Superb

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