Forum Discussion
jattboard
Aug 11, 2023Copper Contributor
Help in %age increase formula
How can I calculate value to be added to cell E3 that will increase my profit margin to 16.9%. (F7) ?
F3 is (E3+E4)
Thanks for the help
1 Reply
Sort By
- PeterBartholomew1Silver Contributor
Your formula for percentage profit was
= (revenue + topup - cost) / (revenue + topup)
in which case, the topup required is given by
= Cost / (1-target) - Revenue