CALCULATE GST AMOUNT FROM AMOUNT IN OTHER CELL
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 |
CALCULATE GST AMOUNT FROM AMOUNT IN OTHER CELL
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 --- "Cruisie Suzie" wrote: 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 |
All times are GMT +1. The time now is 09:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com