Home     Forum     401k     401k Rollovers
    Register   Login   Members   Search   FAQs     Recent Posts    




I need an EXCEL formula to calculate GST (10%)?

Reply to topic
Money Talk > Credit & Loans

Author Thread
Bradford
Member


Cash: $ 3.25

Posts: 15
Joined: 23 Feb 2015

I need an EXCEL formula to calculate GST (10%)?  Reply with quote  

I need a formula for excel that will let me enter a number which will populate a cell telling me how much of that number is GST (this is 10%) and another which tells me the total minus GST.
Post Fri Mar 20, 2015 10:11 pm
 View user's profile Send private message
Wino
Senior Member


Cash: $ 113.80

Posts: 560
Joined: 03 Aug 2012
Location: Dubai
Re: I need an EXCEL formula to calculate GST (10%)?  Reply with quote  

quote:
Originally posted by Bradford
I need a formula for excel that will let me enter a number which will populate a cell telling me how much of that number is GST (this is 10%) and another which tells me the total minus GST.

Are you saying that you know the total, the total contains the original price plus 10%, and you want to know the two components (cost and the 10%)?

If the above is correct, and the amount is in cell A1, the formula for original amount is:
=A1/1.1

You can then take 10% of that, which is:
=A1/1.1*.1

I could make the formula a little simpler, but this keeps the math easy to understand (I think it's easy to understand, anyway).
Post Sun Mar 22, 2015 3:28 am
 View user's profile Send private message

Reply to topic
Forum Jump:
Jump to:  
  Display posts from previous:      





Money Talk © 2003-2016