make negative number value to zero

I

india0693

6
8
-2.00


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

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