Hi
Another one:
=MAX(0,A1-40)
--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets
"mdavis" wrote in message
...
I am attempting to write a formula that will calculate the variance
between
the sum of a cell and the number 40, but only if the sum of that cell is
greater than the number 40? I have tried several functions; i.e.: IF,
SUMIF,
Etc., but I am unable to crack it. Can you help?
Much appreciated,
M
|