Formula Help

  • Thread starter Thread starter Steve Kay
  • Start date Start date
S

Steve Kay

HI, I am having trouble with this

=IF(AND(A1>0,A1<=50),50,""),IF(A1>50,A1<100),100,""),IF
(A1>100,A1<=150),200,"")

can anyone see where the error is?

I would like

If A1 has a value between 0 & 50 then place -->50
If A1 has a value betwwen 50 & 100 then place --> 100
If A1 has a value between 100 & 150 then place -->200

Thanks for you help :-)
 
Hi
try
=IF(AND(A1>0,A1<=50),50,IF(A1>50,A1<100),100,IF(A1>100,A1<=150),200,"")
))
 
HI Frank:

Yesterday I tried this (recommended from you).. but it
gives me errors.. and I cant solve it...

Hi Steve
one way:
IF(AND(A1>0,A1<=50),50,IF(AND(A1>50,A1<=100),100,IF
(A1>100,A1<=150),150
,"don't know")))
 
Hi
try
=IF(AND(A1>0,A1<=50),50,IF(AND(A1>50,A1<100),100,IF(AND(A1>100,A1<=150)
,200,"")))
 
Back
Top