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.

"IHateComputers" <IHateComputers@discussions.microsoft.com> wrote in message
news:81A1731A-3563-4028-A7D4-4209EBF244A5@microsoft.com...[color=blue]
>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.[/color]


You need to go to the MS Excel group...please

--
BobF.

You'll get faster help if post this message to one of the Excel discussion
groups. Here are the links to those groups.

[url]http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.excel[/url]

[url]http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.excel.misc[/url]

--

Ronnie Vernon
Microsoft MVP
Windows Desktop Experience


"IHateComputers" <IHateComputers@discussions.microsoft.com> wrote in message
news:81A1731A-3563-4028-A7D4-4209EBF244A5@microsoft.com...[color=blue]
>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.[/color]