software

What modifications do I need to make to a formula to return zero when the
answer is 0 or lt; 0?

JRTardif., maybe =IF(A1lt;=0,0,quot;more than 0quot;)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003

quot;JRTardifquot; gt; wrote in message
...
gt; What modifications do I need to make to a formula to return zero when
the
gt; answer is 0 or lt; 0?

Try

=MAX(formula,0)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=541861Paul B, The lt;=0 works perfect but I want the real answer if the result is
gt;0 as apposed to quot;more than 0quot;. Thank you for your help.

quot;Paul Bquot; wrote:

gt; JRTardif., maybe =IF(A1lt;=0,0,quot;more than 0quot;)
gt;
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;JRTardifquot; gt; wrote in message
gt; ...
gt; gt; What modifications do I need to make to a formula to return zero when
gt; the
gt; gt; answer is 0 or lt; 0?
gt;
gt;
gt;

=IF(A1lt;=0,0,A1)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003

quot;JRTardifquot; gt; wrote in message
...
gt; Paul B, The lt;=0 works perfect but I want the real answer if the result
is
gt; gt;0 as apposed to quot;more than 0quot;. Thank you for your help.
gt;
gt; quot;Paul Bquot; wrote:
gt;
gt; gt; JRTardif., maybe =IF(A1lt;=0,0,quot;more than 0quot;)
gt; gt;
gt; gt; --
gt; gt; Paul B
gt; gt; Always backup your data before trying something new
gt; gt; Please post any response to the newsgroups so others can benefit from it
gt; gt; Feedback on answers is always appreciated!
gt; gt; Using Excel 2002 amp; 2003
gt; gt;
gt; gt; quot;JRTardifquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; What modifications do I need to make to a formula to return zero
when
gt; gt; the
gt; gt; gt; answer is 0 or lt; 0?
gt; gt;
gt; gt;
gt; gt;