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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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

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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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

Perhaps

=IF(A1200,A1,IF(A1150,200,0))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=521564

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


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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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

thanks

"daddylonglegs" wrote:


Perhaps

=IF(A1200,A1,IF(A1150,200,0))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=521564