Difficult Equation, Newbie

[julienn25]

I need some help to make a excel so i dont have to do same step everytime,
I would like to make a "macro?" so that i put in how much my salespersonal makes and that excel looks in the table and if someone has sold for 10 000 it finds that he gets 20% of 10 000 and so on. if its hard to understand what i mean tell me and i will try to explain in another way



Name Money % to pay
name 1 10 000
name 2 55 000
name 3 99 999




0-49999 20%
50 000-99 999 25%
100 000-149 999 30%
150 000-199 999 35%
200 000-499 999 40%

[Steffen Thomsen]

This prompt for a input value and calculates the commision

Please Login or Register  to view this content.

[Marcol]

Or use this formula

Please Login or Register  to view this content.

[julienn25]

Thank you very much!!!!