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
monisankar_dutt wrote:
use more than 7 if condition in a cell
01Mar08
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 lik
=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
Previous Posts In This Thread:
use more than 7 if condition in a cell
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 lik
=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
Would this work instead?
Would this work instead
=ROUNDDOWN(A1,2)/10

HTH :>
Dana DeLouis
First, why the quotes?
First, why the quotes? Why no
=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)/10
best wishe

Bernard V Liengm
Microsoft Excel MV
http://people.stfx.ca/bliengm
remove caps from emai
Re: use more than 7 if condition in a cell
Does
=INT(CEILING((A1/100),1)
do what you want or do you want "Out of Range to show as well
=IF(A1<100000,"Out of range",INT(CEILING((A1/100),1))

HT
Sand
In Perth, the ancient capital of Scotlan
and the crowning place of king
(email address removed)
Replace @mailinator.com with @tiscali.co.u
Re: use more than 7 if condition in a cell
=IF(A1=0,"0",INT(A1/100) +1

Jim Con
San Francisco, US
http://www.realezsites.com/bus/primitivesoftwar
(Excel Addins / Excel Programming
"Montu
wrote in messag
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 lik
=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 lik
=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",......t
be continued the end of require,"Out of Range")))))))))))))....
is there any solution for the above problem
Thanks in advance
use more than 7 if condition in a cell  monisankar_dutt
The solutions to the 7 issue is available out here, however have you considered just using the INT formula in the cell/cells where you want the 1 or 2 or x etc?
=INT(A1/100) in any cell other than A1 will result in the number 1, assuming cell A1 holds any number from 100 to 199, etc.
Example: cell A1 has the number 257
if cell A2 has the formula =INT(A1/100)
the result in A2 will be the whole number 2
if condition
more than 9 if condition not calculate
Submitted via EggHeadCafe  Software Developer Portal of Choice
Working with Compressed Resources in .NET
http://www.eggheadcafe.com/tutorial...0c314ccfc92e8/workingwithcompressedr.aspx