Hello friends
I would like to explain you my requirement.
I have a sheet with 15 employee and their monthly based information,As you can see in attached file a red box with a main heading with 2 sub columns have the information of trips + commission, now i would like to represent the sub...
Hi,
I am attempting to use a Sumproduct Froumla to work out commission but it isn't quite working.
The below is what I am attempting.
<colgroup><col><col><col><col></colgroup><tbody>
Profit
1000
Starters
1
Actual starters
16
16000
Commision:
3194.8...
i will pay my sales person as following rates i need a formula to execute this
from 1 to 1000000 6%
from 1000000 to 1500000 7%
from 1500001 to 2000000 8%
from 2000001 to 2500000 9%
from 2500001 to 3000000 10%
from 3000001 to 3500000 11%
from 3500001 to 4000000 12%
from 4000001 to 4500000 13%...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.