Wino
Senior Member
Cash: $ 113.80
Posts: 560
Joined: 03 Aug 2012
Location: Dubai 
Re: I need an EXCEL formula to calculate GST (10%)? 


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).
