The calculated number cannot be less than zero.

You should have posted the formula.

Try changing your current formula to something like this:

=MAX(0,your_current_formula_here)

--
Biff
Microsoft Excel MVP


"CindyMc" wrote in message
...
I have a list of 4 numbers with a sum at the bottom. One of the 4 numbers
is
a calculation, the others are direct entry. The calculated number cannot
be
less than zero. How do I fix this so it doesn't allow this when the
number
is calculated?