Advanced formula required please

[zouraiz]

Hi All,

I need an advanced formula to calculate the bonus in my output column in excel sheet.i have filled the desired output but i don't know how to calculate the formula. i used the hurdle lookup table to calculate the output but i wanted to calculate through a formula. Please help me to figure it out. Thanks in advance.

[Winon]

Hello zouraiz,

Could you please tell me, how you calculated 12.3 in Row3 of your sample Workbook?

Should it not be 6.15?

[MarvinP]

Hi,

This looks like a VLookup answer with a True as the last argument. See:
http://www.useexcel.com/vlookup.aspx
for an example using commission.

[zouraiz]

Hello zouraiz,

Could you please tell me, how you calculated 12.3 in Row3 of your sample Workbook?

Should it not be 6.15?

first its achievement 82% that means they qualify for 2% bonus. 2% of 820 multiply by .75 = 12.3. hope you got my point. Thanks

[alansidman]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Winon]

Thank you for your response.

You have now messed up my solution terribly.

But I'll get there.

[Winon]

Hello zouraiz,

Please change your Thread Title to: Formula to Calculate variable percentages

Thank you.

Regards

[sktneer]

first its achievement 82% that means they qualify for 2% bonus. 2% of 820 multiply by .75 = 12.3. hope you got my point. Thanks

What is your bonus classification? I mean what is bonus for less than 80% and more than 125%? What's your rule for deciding bonus based on percentage achievement?

[alansidman]

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

This thread has been closed. You may begin a new thread with a proper title.