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

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..display "0", if greater than... display actual
 

=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

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

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..display "0", if greater than... display actual
 

=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

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

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