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.

"IHateComputers" <> wrote in message
news:81A1731A-3563-4028-A7D4-...
>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.

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" <> wrote in message
news:81A1731A-3563-4028-A7D4-...
>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.