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.
|