when I enter that function in cell A3....it gave me the wrong answer.
In cell A3, it gave me (3) as the answer.....I used this formula:
If your numbers are in A1=3 to A2=8,
=IF(A1<0,0,A1)
-I am looking for a way to calculate only zero instead of going below
0.-
example:
3
8
-5 (instead of -5, I am looking for a way to make it calculate to the
number zero)
However, if switch around the correct answer will be positive 5...
???But how do I make the answer show the number zero if it becomes
(-5)????
--
india0693
------------------------------------------------------------------------
india0693's Profile:
http://www.excelforum.com/member.php...o&userid=25663
View this thread:
http://www.excelforum.com/showthread...hreadid=390804