how do i use macros to work out commissions

[cheltthai]

i need to be able to calculat commissions on a sliding scale from an agreed
sales figure

 

[Barb Reinhardt]

You'll need to provide more information if you want an answer.

 

[JE McGimpsey]

You may not need macros. See

http://www.mcgimpsey.com/excel/variablerate.html

If you DO need it to be a macro, then you need to provide full
information about how the commission schedule is structured.