Hi Everyone,
I have a table that calculates the revenue and expenses per quarter of the selected fiscal years. For the selected fiscal year, its easy to get what the profit percentage is for the quarters. But I want to be able to calculate the profit percentage difference is for the selected...
I have a project I am working on where the retention changes from 10% to 5% at 50% complete.
Example:
Project value: $120,000.00
Value at 50% complete = $60,000
up to 50% complete I need to withhold 10% ($6000)
after 50% (51% or more) I need to withhold 5% until 100% complete (additional $3000)...
How do I use the below formula to output a percentage of F10 instead of a decimal?
Also, is there a way to automatically make it + or - depending on an increase or ad decrease of growth?
I am not good at math! I am a little better at formulas but really stumped on this one.
Example #1: Brian Johnson donated $250 in 2014. He donated $100 in 2015. What formula do I need to use to come up with the difference? The boss wants these in percentages.
Example #2: Mary Jones donated...
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.