## [mso] Re: Excel Formula

• From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
• To: <mso@xxxxxxxxxxxxx>
• Date: Wed, 21 Jun 2006 22:54:48 -0400

Sorry. You lost me.  What are you currently doing with the number in B if it
IS 450?  Your formula refers to D and C, but not B ... You say you need E to
show what it would have been if 450 was in B, but your formula doesn't refer
to B at all.  So, how does what is in B effect what is in E?

Linda F. Johnson
Linda's Computer Stop
Author, MOS: Excel 2003 Study Guide, published by John Wiley and Sons
http://personal-computer-tutor.com

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Chuck Hawsey
Sent: Wednesday, June 21, 2006 8:50 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Excel Formula

Well, here I am with need of a formula that - hopefully - is at least a
little harder than the last one I asked!  I'm not sure how to describe what
I need, so let me try this:
A.               B                        C                        D
E
# of calls

A is self explanatory
B contains the number of minutes worked - usually 450, but it can vary
greatly
C contains a manually entered number of minutes a person spent on
miscellaneous items. For each 32 minutes, he/she gets credit for one
D contains a manually entered number of actual calls made by that person
during the minutes he/she worked
E contains a formula that presently adds the number in D to C divided by 32

Here's my problem. If B contains a number other than 450, I want E to
actually worked 450 minutes.  In other works, I'm looking for a formula like
a ratio, for example, if B contained 248 minutes worked and D contained 8
calls, then I need the number if E to be what it would have been if B had
contained 450 minutes worked.

Gosh, I hope this makes sense, as I find it hard to explain and even harder
to come ;up with a formula. Any assistance will be greatly appreciated. If
will be happy to provide it.

Chuck H.

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions.  Once you are a member of the files group, you can go here to