|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
03-06-2008
| #1 (permalink) |
| | Excel IF Function Help I have a project that requires me to calculate employee bonuses. If the actual fees do not exceed the estimates, then the employee receives a 100 bonus. This is calculated by (actual-estimate)*bonus rate if ( actual-estimate)>0, 100 otherwise. This is a completely different language for me. If someone can decode this and tell me how I can put this into a formula in excel, that would be great. |
My System Specs |
|
03-06-2008
| #2 (permalink) |
| | Re: Excel IF Function Help "IHateComputers" <IHateComputers@xxxxxx> wrote in message news:81A1731A-3563-4028-A7D4-4209EBF244A5@xxxxxx Quote: >I have a project that requires me to calculate employee bonuses. > > If the actual fees do not exceed the estimates, then the employee receives > a > 100 bonus. This is calculated by (actual-estimate)*bonus rate if ( > actual-estimate)>0, 100 otherwise. > > This is a completely different language for me. If someone can decode this > and tell me how I can put this into a formula in excel, that would be > great. You need to go to the MS Excel group...please -- BobF. |
| My System Specs |
|
03-06-2008
| #3 (permalink) |
| | Re: Excel IF Function Help You'll get faster help if post this message to one of the Excel discussion groups. Here are the links to those groups. http://www.microsoft.com/communities...t.public.excel http://www.microsoft.com/communities...lic.excel.misc -- Ronnie Vernon Microsoft MVP Windows Desktop Experience "IHateComputers" <IHateComputers@xxxxxx> wrote in message news:81A1731A-3563-4028-A7D4-4209EBF244A5@xxxxxx Quote: >I have a project that requires me to calculate employee bonuses. > > If the actual fees do not exceed the estimates, then the employee receives > a > 100 bonus. This is calculated by (actual-estimate)*bonus rate if ( > actual-estimate)>0, 100 otherwise. > > This is a completely different language for me. If someone can decode this > and tell me how I can put this into a formula in excel, that would be > great. |
| My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Re: Calling excel function | VB Script | |||
| VBScript to search LDAP from Excel function? | VB Script | |||
| Is there a write-multi-cell-at-once function in VBS for Excel? | VB Script | |||
| Excel function | Vista General | |||
| VBA Function not recognized in Excel | Vista General | |||
