-2

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?

Improve this question
2
  • I fail to see what the OS version has to do with this. It is purely a 'how do I use excel' question.
    – Hennes
    Nov 28, 2013 at 0:01
  • I mean, 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 # 123.00. This 123.00 has to be in Q45. Hence what formula to put in Q45 so I get 123.00 set up here
    – Kamlesh
    Nov 29, 2013 at 5:09

1 Answer 1

Reset to default
1

=(N45-(N45*0.07))+P45 probably, but it is not particularly clear exactly what you want to achieve.

Improve this answer
2
  • I mean, 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 # 123.00. This 123.00 has to be in Q45. Hence what formula to put in Q45 so I get 123.00 set up here.
    – Kamlesh
    Nov 29, 2013 at 5:08
  • thz, but got some help from Microsoft.com, and put 2 and 2 together, and there you go!! I did =93%*N45+O45. DONE!!
    – Kamlesh
    Nov 29, 2013 at 6:25

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .