| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate amount of change in a single cell | Excel Discussion (Misc queries) | |||
| Calculate amount of change in a single cell | Excel Discussion (Misc queries) | |||
| sales tax total amount from one cell amount to another cell | Excel Discussion (Misc queries) | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Hybrid Mode
