Forum Discussion

jattboard's avatar
jattboard
Copper Contributor
Aug 11, 2023

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

  • jattboard 

    Your formula for percentage profit was

    = (revenue + topup - cost) / (revenue + topup)

    in which case, the topup required is given by

    = Cost / (1-target) - Revenue

     

Resources