ExcelBanter - Multiple IF statements in one cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Multiple IF statements in one cell (https://www.excelbanter.com/excel-programming/360243-multiple-if-statements-one-cell.html)

Jones E[_2_]

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.

Gary Keramidas

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.

excelent

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.

Jones E[_2_]

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.

All times are GMT +1. The time now is 04:57 PM.