Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple IF statements in one cell
It seems that I can only put 7 IF statements in one cell. Is there any way
that I can put more than just 7 IF statements in one cell? I'm looking to use atleast 10. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple IF statements in one cell
try chip pearson's site
http://www.cpearson.com/excel/nested.htm -- Gary "Jones E" wrote in message ... It seems that I can only put 7 IF statements in one cell. Is there any way that I can put more than just 7 IF statements in one cell? I'm looking to use atleast 10. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple IF statements in one cell
=IF(1=1;IF(1=1;IF(1=1;IF(1=1;IF(1=1;IF(1=1;IF(1=1; IF(1=1;;))))))))+IF(1=1;IF(1=1;1;0))
"Gary Keramidas" skrev: try chip pearson's site http://www.cpearson.com/excel/nested.htm -- Gary "Jones E" wrote in message ... It seems that I can only put 7 IF statements in one cell. Is there any way that I can put more than just 7 IF statements in one cell? I'm looking to use atleast 10. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple IF statements in one cell
Thanks for your help
"excelent" wrote: =IF(1=1;IF(1=1;IF(1=1;IF(1=1;IF(1=1;IF(1=1;IF(1=1; IF(1=1;;))))))))+IF(1=1;IF(1=1;1;0)) "Gary Keramidas" skrev: try chip pearson's site http://www.cpearson.com/excel/nested.htm -- Gary "Jones E" wrote in message ... It seems that I can only put 7 IF statements in one cell. Is there any way that I can put more than just 7 IF statements in one cell? I'm looking to use atleast 10. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple If Statements in the same cell | Excel Worksheet Functions | |||
Multiple IF statements looking up multiple ranges. | Excel Worksheet Functions | |||
Multiple if statements I think | Excel Worksheet Functions | |||
Multiple if statements with multiple conditions | Excel Discussion (Misc queries) | |||
Multiple "IF" statements every cell in range | Excel Programming |