=IF(ISTEXT(A1),"",IF(AND(A1=1,A1<=149),0,IF(A1=1 50,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



"JcR" wrote in message
...
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