I need assistance with wrting an Excel formula

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

Hi

not sure what you mean by "the sum of a cell" but is this what you're after

=IF(A1>40,A1-40,0)

if not, please post back with additional details (ie what cell(s) you're
talking about, what is actually in those cells).
Cheers
JulieD

"mdavis" <[email protected]> wrote in message
news:[email protected]...
>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

Hi

Another one:
=MAX(0,A1-40)

--
When sending mail, use address arvil<at>tarkon.ee
Arvi Laanemets


"mdavis" <[email protected]> wrote in message
news:[email protected]...
> 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