Formula to calculate commission based on sliding scale

E

Excel Dumbo

Hello,

Please refer attached file

I would like to get a formula to calculate commission based on a slidin
scale table shown in the file.

Any help will be greatly appreciated.

Regards,
Dumb

+-------------------------------------------------------------------
|Filename: Formual to calculation Commission.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=825
+-------------------------------------------------------------------
 
S

shanermuls

Excel said:
Hello,

Please refer attached file

I would like to get a formula to calculate commission based on a slidin
scale table shown in the file.

Any help will be greatly appreciated.

Regards,
Dumbo
Click to expand...

Attached - a few adjustments necessary to table of reward

+-------------------------------------------------------------------
|Filename: Formual to calculation Commission.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=826
+-------------------------------------------------------------------
 
E

Excel Dumbo

Thanks a lot Shaneer Muls...It worked wel

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formual to lookup sumtotal from data with spaces 3
Formula to calculate Rank and % growth 2
Complicated Match Formula with conditions 2
Look UP formula for 2 and 3 conditions 1
Look UP and then caluclation with IS ERROR 3
Formula- Count of items that meet a specific range criteria 4
LookUP certain words and return back corresponding values 2
Vlookup using two criteria -not working 2

Top