From: Stan Brown on
On Tue, 1 Jun 2010 19:12:01 -0700, =?Utf-8?B?R2VuZSBNY0s=?= wrote:
>
> How do I put this into a spread sheet?

I note that others have responded to the actual question, but I'd
like to take the liberty of philosophizing.

Without context, this looks like a homework question. It might not
be one, but it looks like it.

Leaving out the ethical implications of just giving answers to
homework, as opposed to asking leading questions that help the person
see her way to a solution, there's a larger issue: if the OP has no
idea how to write this extremely simple formula, then she is really
in trouble in the course and should get some help, pronto. What will
happen when she has to do something harder, like an IF or a SUMIF?

I see this all the time in my statistics classes: students who don't
really "get" the concepts tend to focus on each homework problem as a
completely unique experience. They heave a sigh of relief when
they've got through the homework problems, even if they had no idea
what the people who "helped" them were doing. But then they do
really poorly on quizzes because the quiz problems are not
*identical* to the homework.

I know this isn't a homework help group, and again I have misread the
motivation of the original question, but to the OP I say:

if this is homework, and you couldn't do it yourself, go to your
instructor NOW, admit that you're lost, and ask for help. If you
just drift along you will not magically see the light at some point;
instead you'll just fall further and further behind.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...