Hello! In need of assistance to build functional tool to help sales agents track monthly commissions. The commission rate is applied to monthly sales and the rate increases as accumulated annual sales reach specified thresholds. I'm having trouble entering formulas in the "Monthly Incentive"...
Hello Guys,
I am working on a Daily Production Status Monitoring file.
I do get daily figures from the quality controller but only the total figure (accumulated figure) by the end of the day.
For Example
Lets say if production on day 1 is 100 pieces and day 2 is 110 pieces.
for 1st day i...
Is there a formula to calculate a accumulated compound interest rates factor from/till any given month/year?
For example, I have a table with month interest rates:
A B
1 Oct/2017 1%
2 Nov/2017 3%
3 Dec/2017 4%
4 Jan/2018 2%
5 Feb/2018 5%
6 Mar/2018 2%
So If I wan't to get the accumulated...
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.