Excel Nested AND function

Рет қаралды 33,767

12 жыл бұрын

This video shows how and why to Nest an AND function inside an IF function in Excel. If you are new to IF functions or AND functions I have made a video that introduces the basics of each linked here:
• Excel IF function
I have also made a Nested OR function video linked here:
• Excel Nested OR function

Пікірлер: 20

@nlbatebr 8 жыл бұрын

Thanks for that. Nested IFs, ANDs, ORs frequently confuse me and you did it in a really simple way. Keep it up.

@andrew92884 12 жыл бұрын

i learned more from you in an hour than from my professor all year and i have a final in an hour! THANKS SO MUCH!

@kessac4605 Жыл бұрын

Your videos have helped me!!

@lastwitness1 11 жыл бұрын

Many teachers suck because they A) don't truly understand what they are teaching, or B) don't know how to explain what they know. You are in category C) a good instructor who both knows what they are talking about and can explain it simple enough so others get it too. I have seen a few videos of your. I like them. So thank you very much, because they help me, whereas the actual program creators 'MS corp' is category B and gives me crap! I give your videos thumbs up.

@kimbalika 9 жыл бұрын

Thank you SO much! This lesson was really frustrating me today, and your video made it all make sense. I really appreciate you sharing your time, efforts and talents here. God bless.

@maggiepuddles2593 10 жыл бұрын

Thank you for the time and effort that you have put into these turorials

@rdjalayer 11 жыл бұрын

thank you for the gracious comment, it was very thoughtful and uplifting

@rabiuharuna9604 3 жыл бұрын

Very good tutorial,

@johnq3543 6 жыл бұрын

This has been a huge help, thank you

@MrElmobde3 8 жыл бұрын

that was amazing bro !! Thanks :))

@Tanushree00099 5 жыл бұрын

Thanks for the video its really helpful. Can you also provide excels to practise at the end of every video.As othewise I have to work really hard to make a data to practise the teaching.

@mariomorenojr6229 8 жыл бұрын

Learning- thanks

@alex9xela 11 жыл бұрын

Thanks!!

@rdjalayer 11 жыл бұрын

thank you

@m-b-m3492 7 жыл бұрын

hi Mr! I have 1, 2, 3 and 4 for codes in a column, but I want to converter negative number for 3 and 4 in column C. how can I get that with if fuction?? thanks! sorry for my bad English!! :)

@pchughes624 11 жыл бұрын

Do you have an Excel total overview video and a word total overview?

@rabindradhital 6 жыл бұрын

I get "No" in all of the cells even though i have copied and repeated your sheet exactly as you did. I dont know what is wrong with my work.

@rdjalayer 11 жыл бұрын

search my channel for beginners excel, there I have over 200 tutorials that range the levels of expertise

@onurciftci877 8 жыл бұрын

dude you should upgrade your computer

@freepilot7732 Жыл бұрын

Everyone. I figured it out. I'm so excited. I was dreaming it lastnight. Just now I just got in my computer and just started typing it out. IT Works!!!!! Here it is. =IF(AND(C25>3000,C21>5),"VFR",IF(AND(OR(C25>=1000),(C21>=3)),"MVFR",IF(AND(OR(C25>=500),(C21>=1)),"IFR","LIFR")))