Pages

Monday, December 27, 2010

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

No comments:

Post a Comment

Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews