return 0 instead of a negative #
Fixed. Thanks Elkar
"Elkar" wrote:
Try this:
=MAX((C6+D14)-H6,0)
HTH,
Elkar
"Rusty" wrote:
I just want to do a simple sum and if the sum returns a negative number, I
want to change it to 0.
C6 = 38, D14 = 2, H6 = 43
=(C6+D14)-H6
result is -3 but I want it to show 0
|