=IF(A1=0,"0",INT(A1/100) +1)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"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