*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 Name minutes worked downtime actual calls made adjusted # 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 adjusted call. 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 represent the number of adjusted calls he/she would have had if he/she had 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. ************************************************************* 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, you can go here to upload/download files: 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 *************************************************************

**Follow-Ups**:**[mso] Re: Excel Formula***From:*Chuck Hawsey

**[mso] Re: Excel Formula***From:*Chuck Hawsey

**References**:**[mso] Excel Formula***From:*Chuck Hawsey

- » [mso] Excel Formula
- » [mso] Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula
- » [mso] Re: Excel Formula