return 0 instead of a negative #

[Rusty]

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

[Elkar]

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

[Rusty]

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

[JE McGimpsey]

One way:

=MAX(C6+D14-H6,0)

In article <[email protected]>,
"Rusty" <[email protected]> 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