make negative number value to zero

[india0693]

6
8
-2.00


Can someone tell me instead of the negative -2.
How do I make the value equal to 0

 

[india0693]

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)????

 

[Ragdyer]

=MAX(your formula,0)

 

[olasa]

Sorry, I misunderstood your question.

This is one way: =IF(A1-A2<0,0,A1-A2)

Ola Sandström


Here's a short video of the IF-function:
http://www.auditexcel.co.za/docs2/IF.wmv