How to write Microsoft Excel 2016 nested IF statements

Learn how to write nested "if" statements in the Microsoft excel document

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

In the appeared window in "Logical_test" line select B2 cell and type "more or equa l90000". 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 "more or equa l80000". 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