If...then "0", if greater than, then enter actual

[Guest]

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Bob,

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

 

[daddylonglegs]

Perhaps

=IF(A1>200,A1,IF(A1>150,200,0))

 

[CLR]

What results would you like if A1 is blank?, or if A1 contains a negative
number?, or if A1 contains any number "between" 149 and 150?, or if A1
cantains TEXT?

If you don't consider those conditions in the formula, Excel will
automatically do it for you and you may not like the results.

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

thanks