Hello everyone. I have another (PROBABLY VERY EASY) question for you. It seems like I should know how to do this, but it just isn't working right. Maybe I am just missing something.
My company is trying to automate a bidding process by creating a spreadsheet to help with the calculations and make this faster. I need a formula to calculate profit dollars based on a desired profit percentage.
For example:
A10 says subtotal (It is the total of all the aspects of the bid without profit) (A4 to A8) Lets say the total of the services required adds up to $1,000
A11 says Profit % (It is the percentage profit the salesman is seeking in the sale) Lets say they are wanting 11% profit.
A12 says Profit $ and should say $123.60
A13 is Total and that one is just a sum of A10 and A12 and would say $1,123.60
Subtotal - $1000
Profit % - 11%
Profit $ - $123.60
Total - $1,123.60
Thank you for any help you can give me on this. It seems like it should be easy, but for some reason, I am blanking on it.
My company is trying to automate a bidding process by creating a spreadsheet to help with the calculations and make this faster. I need a formula to calculate profit dollars based on a desired profit percentage.
For example:
A10 says subtotal (It is the total of all the aspects of the bid without profit) (A4 to A8) Lets say the total of the services required adds up to $1,000
A11 says Profit % (It is the percentage profit the salesman is seeking in the sale) Lets say they are wanting 11% profit.
A12 says Profit $ and should say $123.60
A13 is Total and that one is just a sum of A10 and A12 and would say $1,123.60
Subtotal - $1000
Profit % - 11%
Profit $ - $123.60
Total - $1,123.60
Thank you for any help you can give me on this. It seems like it should be easy, but for some reason, I am blanking on it.