| 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 | |||
![Jones E[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
