Formula Help

[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

 

[Frank Kabel]

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

 

[Steve Kay]

Hi there, I keep getting an Error.. arrggghhh and F1
doesnt really help.

 

[steve Kay]

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")))

 

[Frank Kabel]

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

 

[Guest]

You have an AND function embedded in the first term. Is
this causing problems?

 

[shinos]

Hi
Try this:
=IF(A1>150,"",IF(A1>100,200,IF(A1>50,100,IF(A1>=0,50,""))))
HTH
shinos