J
JRTardif
What modifications do I need to make to a formula to return zero when the
answer is 0 or < 0?
answer is 0 or < 0?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Paul B
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
--
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
D
daddylonglegs
Try
=MAX(formula,0
=MAX(formula,0
J
JRTardif
Paul B, The <=0 works perfect but I want the real answer if the result is
P
Paul B
=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
--
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