# [mso] Re: Excel Formula

• From: "David Smart" <smartware@xxxxxxxxxxxxxxx>
• To: <mso@xxxxxxxxxxxxx>
• Date: Thu, 22 Jun 2006 14:23:53 +1000

```Let's work on Row 2:

In E2:

=D2*450/B2

Now that will give you a non-integer number of calls (e.g. in your case, the
result is 14.516129).  You can round to the nearest integer:

=ROUND(D2*450/B2,0)

or truncate the fractional part off completely

=ROUNDDOWN(D2*450/B2,0)
=INT(D2*450/B2)

(these two truncation formulae are essentially the same in this case).

You haven't mentioned whether you want the credits included.  The fairest
method that I can see would be:

adjust calls by 450 / minutes worked, leave fractional part in
add downtime / 32, leave fractional part in
then round the result up or down to the nearest integer.

=ROUND(D2*450/B2+C2/32,0)

Regards, Dave S

----- Original Message -----
From: "Chuck Hawsey" <chawsey@xxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Thursday, June 22, 2006 10:50 AM
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
> Name    minutes worked    downtime        actual calls made
>
>
> 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 anyone needs more information or needs the actual present
> spreadsheet, I will be happy to provide it.
>
>
>
> Chuck H.
>
> This email and any attachments have been scanned by Norton AV Version
> 11.0.16.2
> *************************************************************
> 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 menu at the top.  This will allow you to unsubscribe your email
> address or 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,
> http://www.smartgroups.com/vault/msofiles
>
> If you are using Outlook and you see a lot of unnecessary code in your
> email messages, read these instructions that explain why and how to fix
> it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************

*************************************************************
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
http://www.smartgroups.com/vault/msofiles

If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
```