CALCULATE GST AMOUNT FROM AMOUNT IN OTHER CELL

[Cruisie Suzie]

Does anyone know what formula to insert in cell B1 to calculate the gst
component of an amount (which includes gst) in cell A1? Would appreciate your
help.
Novice excel user

 

[Max]

Something like this ..
Assuming GST = 3% = 0.03
and A1 contains the Amt (inclusive GST)
Then in B1: =(A1/(1+0.03))*0.03
will return the GST amt
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik