Use the IF function combined in one cell more than seven times - Logical Functions - Microsoft Excel Tutorials

15.  Use the IF function combined in one cell more than seven times

The Excel online help says that it is not possible to combine the IF function more than seven times. That is not true, as shown below.

To insert more than seven conditions:

1. Select cell A1 and enter 12.
2. Select cell B1 and type the following formula:

=IF(A2=1,A2,IF(A2=2,A2*2,IF(A2=3,A2*3,IF(A2=4 ,A2*4,IF(A2=5,A2*5,IF(A2=6,A2*6,IF(A2=7,A2*7,)))))))+IF(A2=8,A2*8,IF(A2=9,A2*9,IF(A2=10,A2*10,)))+IF(A2=11,A2*11,IF(A2=12,A2*12,)).

3. Press <-Enter->.

Watch the Video Tutorial - https://www.youtube.com/watch?v=cr3yOPVMsYw

  Hope You Like This Tutorial - Give Comments

Use the IF function to check for larger, equivalent, or smaller values - Logical Functions - Microsoft Excel Tutorials

6.  Use the IF function to check for larger, equivalent, or smaller values

In the previous example, two different messages were used as the result for comparing values. To check for three conditions in column A and present the result as “Column A is larger,” “equal,” or “Column A is smaller,” perform the following steps.

To compare columns and show the result:

1. Copy the previous example.
2. Select cells C2:C12 and type the following formula: =IF(A2>B2,"Column A is larger",IF(A2=B2,"equal",
"Column A is smaller")).
3. Press <-Ctrl+Enter->.

Note: Up to seven IF functions can be combined in one cell.  To combine more than seven functions, use the customized  solution near the end of this chapter.



Watch the Video Tutorial - https://www.youtube.com/watch?v=CbmCL1OvC88

Hope You Like This Tutorials, Give Comments