software

If value in cell a1 = 1 through 149, display quot;0quot; in a2
If vallue in cell a1 = 150 or greater, display actual value of a1, in cell a2
=if(a1lt;150,0,a1)--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=521560see response in public.excel

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;JcRquot; gt; wrote in message
...
gt; If value in cell a1 = 1 through 149, display quot;0quot; in a2
gt; If vallue in cell a1 = 150 or greater, display actual value of a1, in cell
a2
gt;
=IF(ISTEXT(A1),quot;quot;,IF(AND(A1gt;=1,A1lt;=149),0,IF(A1gt;=1 50,A1,quot;quot;)))

This will return a blank cell for a value in A1 that is quot;less than 1quot;, quot;any
number that is greater than 140 and less than 150quot;, quot;and any
textquot;...........otherwise, it will do as you ask.....

Vaya con Dios,
Chuck, CABGx3
quot;JcRquot; gt; wrote in message
...
gt; If value in cell a1 = 1 through 149, display quot;0quot; in a2
gt; If vallue in cell a1 = 150 or greater, display actual value of a1, in cell
a2
gt;
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

quot;davesexcelquot; wrote:

gt;
gt; =if(a1lt;150,0,a1)
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=521560
gt;
gt;