Microsoft Excel Tutorial for Beginners #17 - Using Nested 'IF' Functions

Visit MotionTraining at http://www.motiontrainingweb.com
Learn how to extend the IF Function to include more than one question (or logical test) in one function. Hope you find this useful. More tutorials soon!

Category:

Howto & Style

Tags:

• Microsoft
• MS
• Excel
• Calculations
• Formula
• Function
• Nested
• If
• Absolute
• Cell
• Reference
• Tutorial
• Video
• Help
• How
• To

[Sureman100]

Thank you so much. I started watching this tutorial because I'm heading into an interview tomorrow, and I need to learn more about Excel. I felt that I've learned a great deal in a short period of time. Eventhough I'm using Excel 2007, I don't have too much problem understanding it from a Excel 2003 perspective.

[j2j3j4j5j6]

A most excellent series of tutorials. Many, many thanks.

[MrAlbionsaint]

Cheers buddy

[crafts]

Thanks again!

[todkie1]

Thanks for making this video! helped me alot in my work.. Keep it up! =)

[IluffLotR]

I love it when you say 'open bracket'. :D

[RPPJ]

Will you be my dad??

[SUZEBRIGHTSTAR]

Excellent tutorials! I started watching these videos around 12m and it is now 2:45 and I can not stop. There are sooo good. Well explained and presented. THANK YOU

[vinoth7007]

Hi I listened to all of your tutorials last night and didn't get bored at all. Well presented.

I hope you wouldnt mind me asking a question

How to set up a work or duty roaster with excel. As you know we will have named shifts ( e.g. Day, night, partial shift etc.,) and each shift extends for a particular period (e.g 13 or 6 or 8 hours and so on)

My question is if we set up a rota with named shifts, can we ask excel to calculate the number of hours worked by a particular person for that we

[captainbrush]

@j2j3j4j5j6 It was most good, Newland, most good...

[06nelson1]

Great tutorials! Great teacher!