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(a1<150,0,a1)


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521560

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

"davesexcel" wrote:


=if(a1<150,0,a1)


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521560

see response in public.excel

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

=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