Nested IF in Microsoft Excel

It is possible to nest multiple IF functions within one Excel formula? Answer is “YES”.
You can nest up to 7 IF functions to create a complex IF THEN ELSE statement.
The syntax for the nesting the IF function is:

IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))

This would be equivalent to the following IF THEN ELSE statement:

IF condition1 THEN
    value_if_true1
ELSEIF condition2 THEN
    value_if_true2
ELSE
    value_if_false2
END IF

This applies to Excel 2010, Excel 2007, Excel 2003, Excel XP and Excel 2000

Reference: Muthukumar (http://nadarmuthukumar.blogspot.in), Ref1
Hope you liked this and let me know your thoughts on post through your comments :)

Posted in: Excel