How to Use If Else If Function in Excel 2013 - Nested If Function in Microsoft Excel
The syntax for the IF function in excel is =if(logial_test,[value_if_true], [value_if_false])
Excel allows one more IF in place of >[value_if_false] to have one more logical test (of course another IF function can also be used in place of [value_if_true]). (For more details on nested functions please refer to the article “Nested Functions in excel 2013”).
Now considering the example below, for bill ID BA200130023 a discount of 8% is allowed, for bill ID BA200130024 a discount of 10% is allowed and so on.
Nested IF can be illustrated in excel as below
The 3rd IF serves as [value_if_false] of 2nd IF, The 2nd IF along with 3rd IF serves as as [value_if_false] of 1st IF.
In our case, the first IF tests whether “Bill Amount” is more than 5000 and returns value in cell B4 when condition is TRUE (“$” symbol before B and 4 denotes absolute cell reference. For more details on Cell Referencing please refer the article absolute, relative and mixed cell reference). If the condition is not true, the 2nd IF in [value_if_false]> will be evaluated and so on.
Hence Nested IF can be composed in excel as illustrated.