How to make value 0 if formula reslut is a negative number

P

pjamieson

New member
Joined
Sep 23, 2015
Messages
3
Reaction score
0
Points
0
I am going to use cell E34 to enter random values, that will be used in a formula in cell G34
The formula in cell G34 is =((E34-813600)*0.5)*0.5
My question is how do I set it up so that if the value I put in E34 is less than 813600, the value that will show up in G34 is 0
I would like to stop the formula from creating a negative number
Thank You, Peter J
 
Not sure why.

If this returns a number:
=((E34-813600)*0.5)*0.5

Then this:
=MAX(((E34-813600)*0.5)*0.5,0)
only ensures that the calculated value will not be less than zero.

Unless your region settings use a semicolon as a delimiter, instead of a comma, it should work.
 
Excellent Ron, it does work, I somehow put an A34 when I transposed this ,, thank you very much from Chatham Ontario, this was very important to me, have a good one Peter jy
 
You must log in or register to reply here.
Back
Top