Using the Nested IF Statement in Excel 2007

In this video tutorial we will show you how to write excel nested “if” statements.


In order to write excel nested “if” statements, open your excel document. For example, click on an empty C2 cell. Go to the “Formulas” tab. Click on “Logical” and select “IF”.

Use IF function

In the appeared window in “Logical_test” line select B2 cell and type “>=90000”. In “Value_if_true” type “9000”. And left “Value_if_false” empty. Then click on a C2 cell formula. Now go to the “Formulas” tab, click on “Logical” and choose “If”. In the “Logical_test” line, click on B2 cell, then type “>=80000”. In “value_if_true” type “5000”. And in the “Value_if_false” line type “1000”.

Now in the place of “1000” in the formula, type “Work harder”. And you will see it in your cells. That’s how to write nested “if” statements in excel.