LinkBack URL
About LinkBacks
Does anyone know what formula to put in the total cell to get the correct answer?
I need to make the price of $100.00 into $179.40 by adding 15%, then 20%, then 30%.
BURDEN OVERHEAD PROFIT TOTAL:
MATERIAL C&M: $100.00 15% 20% 30% ?????
Add percentage multiple times
Does anyone know what formula to put in the total cell to get the correct answer?
I need to make the price of $100.00 into $179.40 by adding 15%, then 20%, then 30%.
BURDEN OVERHEAD PROFIT TOTAL:
MATERIAL C&M: $100.00 15% 20% 30% ?????
Last edited by utilitypigeons; 07-12-2022 at 08:46 AM.
The result is not correct.
A1=€ 100
B1=115%
C1=120%
D1=130%
E1 ==A1*B1*C1*D1
Result € 179,40
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Since I am not able to edit the earlier threath, the formula in E1 should (of course) be
E1 =A1*B1*C1*D1
If you mean you want to start with 100, add 15%, then add 20% to the resulting answer, then add 30% to the resulting answer, then you want:
=100*1.15*1.2*1.3
(replace values with cell references where appropriate)
Your example of 156 is what you get if you do 100*1.2*1.3, you seem to have missed out the 15%.
I corrected my math (I originally had the 15% as 0%).
I tried E1 =A1*B1*C1*D1 and I got an answer of $0.90
You need to add 1 to the percentages, try:
E1=A1*(1+B1)*(1+C1)*(1+D1)
Not for me.
See the attached file.
That worked, Thank you!
@utilitypigeons
You received answer from several members.
Please add to whom you are replying.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks