If..display "0", if greater than... display actual

J

JcR

If value in cell a1 = 1 through 149, display "0" in a2
If vallue in cell a1 = 150 or greater, display actual value of a1, in cell a2
 
B

Bob Phillips

see response in public.excel

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
C

CLR

=IF(ISTEXT(A1),"",IF(AND(A1>=1,A1<=149),0,IF(A1>=150,A1,"")))

This will return a blank cell for a value in A1 that is "less than 1", "any
number that is greater than 140 and less than 150", "and any
text"...........otherwise, it will do as you ask.....

Vaya con Dios,
Chuck, CABGx3
 
J

JcR

Dave,

This is what i'm really trying to get to:
If a1 = 0-149, then a2 = 0
If a1 = 150-200, then a2 = 200
If a1 = 200 or greater, then a2 = a1

Thanks
 
Top