Cash: $ 113.80
Joined: 03 Aug 2012
|Re: I need an EXCEL formula to calculate GST (10%)?
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:
You can then take 10% of that, which is:
I could make the formula a little simpler, but this keeps the math easy to understand (I think it's easy to understand, anyway).