I have the cost of a ticket without taxes on N45
. I want to calculate 7% of that (take out comm. %), then add taxes from P45
, but what formula do I use for that?
Say I have a ticket price for $100.00 (N45
), I take 7% off of this, so now I have 93.00. To this I need to add say $30.00 (ticket taxes on O45
), which brings me to a total of 123.00.
This 123.00 has to be in Q45
.
What formula do I put in Q45
so I get 123.00 there?