15. Use the IF function combined in one cell more than seven times
To insert more than seven conditions:
1. Select cell A1 and enter 12.
2. Select cell B1 and type the following formula:
Watch the Video Tutorial - https://www.youtube.com/watch?v=cr3yOPVMsYw
Hope You Like This Tutorial - Give Comments
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