Cell Validation.

M

Mark Solesbury

Hope you can help.

I have a formula that adds up some numbers in various cells.
I need a validation rule to make the sum of the numbers, if negative, to
show as 0.

I have tried to no avail to get this to work.

Any one got any ideas?

Mark,
 
A

Arvi Laanemets

Hi

When your current formula is
=CurrentFormula
then
=MAX(0,CurrentFormula)
does exactly what you want.
 
Top