Posted to microsoft.public.excel.worksheet.functions
|
|
use more than 7 if condition in a cell
First, why the quotes? Why not
=if(a1=0,0,if(a1<100,1,if(a1<200,2,.......
Second, except in Excel 2007, if more than 7 conditions are needed you have
to look for another solution.
How about : =CEILING(A1,100)/100
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Montu" wrote in message
...
Hi,
I'm getting problem to use more than 7 if condition in a cell in excel
2003,
in there I can input only 7 if condition like
=if(a1=0,"0",if(a1<100,"1",if(a1<200,"2",if(a1<300 ,"3",if(a1<400,"4",if(a1<500,"5",if(a1<600,"6",if( a1<700,"7","Out
of Range")))))))
but I want more condition to be input like
=if(a1=0,"0",if(a1<100,"1",if(a1<200,"2",if(a1<300 ,"3",if(a1<400,"4",if(a1<500,"5",if(a1<600,"6",if( a1<700,"7",if(a1<800,"8",if(a1<900,"9",......to
be continued the end of require,"Out of Range"))))))))))))).....
is there any solution for the above problem.
Thanks in advance
|