Excel IF Function Help

[IHateComputers]

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.

 

[Bob F.]

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

 

[Ronnie Vernon MVP]

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/newsgroups/en-us/default.aspx?dg=microsoft.public.excel

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