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
PeterBartholomew1
Aug 11, 2023Silver 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