Replacing negative formual results with a zero.

[smittys1]

I am doing simple addition and subtraction formulas that result feed into
other formulas so I want to restrict the results to a zero if the initial
formula results revert to zero if they are negative.

[Stefi]

=MAX(0,yourformula)

Regards,
Stefi



„smittys1” ezt �*rta:

> I am doing simple addition and subtraction formulas that result feed into
> other formulas so I want to restrict the results to a zero if the initial
> formula results revert to zero if they are negative.

[robert111]

=if(A1-B1<0,0,A1-B1)