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

JRTardif., maybe =IF(A1<=0,0,"more than 0")

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

"JRTardif" wrote in message
...
What modifications do I need to make to a formula to return zero when
the
answer is 0 or < 0?

Try

=MAX(formula,0)


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

Paul B, The <=0 works perfect but I want the real answer if the result is
0 as apposed to "more than 0". Thank you for your help.

"Paul B" wrote:

JRTardif., maybe =IF(A1<=0,0,"more than 0")

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

"JRTardif" wrote in message
...
What modifications do I need to make to a formula to return zero when
the
answer is 0 or < 0?

=IF(A1<=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 & 2003

"JRTardif" wrote in message
...
Paul B, The <=0 works perfect but I want the real answer if the result
is
0 as apposed to "more than 0". Thank you for your help.

"Paul B" wrote:

JRTardif., maybe =IF(A1<=0,0,"more than 0")

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

"JRTardif" wrote in message
...
What modifications do I need to make to a formula to return zero
when
the
answer is 0 or < 0?