http://www.excelfornoob.com

http://www.subjectmoney.com

This is a Microsoft Excel tutorial for beginners or for dummies showing how to use the IF function in Microsoft Excel 2010. It this tutorial we use three examples with the first showing a simple use of the If function, the second example shows how to use the If function with text and the third example shows how to use the if function for a value range.

Okay, I need help. I get the if and then… but I am trying to figure out how to adjust formatting. Simply, if a value in a cell is greater then 0 I would like the text to be red, but if it is equal to or less then 0 no change. Any helpers out there?

Great lesson. very helpful to me. Thanks.

How to do in excel if I have 3 equation?

For example:

If A, I have to use 1.

If B, I have to use 2.

If C, I have to use 3.

Because in excel, it just have 2 logical test.

If A, true. If B, false.

I have to list the flight hour values for crews 1,2,3. If the crew column displays 1 I have to use the function to calculate the flight hours value of column 1 how do I put that in the IF function?

Great Tutorial. Thanks!

dont know what version you have but i cant do this, maybe its just because i have the starter… either way, i even tried copying your sheet exactly, right down to which cells you put your figures in. So frustrating!

Thank you so much! xx

Great tutorials…. GREAT!

I know lol sorry

LOL! You kept referencing quotes as parenthesis…. but, great tutorial.

Thanks man i have a test tomorrow and u helped me xD 😀 (y)

Thanks!!!!!!!!

I absolutely love this!!! Thanks so much for sharing…

MS Excel Tutorial on the IF Function and how to use the IF Function for a value range.

MS Excel Tutorial on the IF Function and how to use the IF Function for a value range.