gst

Hello wonderful excel people, I am having an issue that has me stumped that I was hoping to get some help on, please. I have a userfrom with a few text boxes for text and services/products to be written and then another 12 textboxes (tb_sprice1 - tb_sprice12), where I'm able to type prices...

I need some help with a formula to calculate this, I think I need a sumif formula but I am not sure. I have a excel table that calculates costs of services. The table is called npss_quote. There is a totals column called "Price ex. GST". There is a drop down menu with 5 services and the...

I have a spreadsheet with a table in it. At the bottom of the table is a field where the GST is calculated for entries in the table. The GST is 10% of the value. I had the following code in it that calculated the GST correctly: =ROUNDDOWN(SUM(npss_quote[Price ex. GST])*0.1,2) There are...

Looking for help with SUMIFS. I need the sum if Column A contains "53", "Vat" or both. <tbody> Charge Amount C5305-R-D - Duty 83,942 C5315-R-D - Gst Paid 411,816 5315-R-D - Cisf 2,985 5315-E-D - Gst Paid 233,045 153-R-D - Cisf 2,985 153-R-O - Cisf 32,410 VAT-E-D - Customs Vat...

Hi Need tutoring or tips to help me calculate increasing an amount by 3.1% CPI and 10% GST over 3 years. For the first year I have a starting amount of rent at 7300 which is required to be increased by 10% GST. I have calculated this to be 8030 - 7300*(1+0.10). No CPI is included in this first...

Hi I have this table and I need to add 10% GST and CPI of 3.1%. I know adding 10% to rent of 7300 equals 8030. Then I'm lost - do I need to add GST to year 2 & 3 or is this already included from year1. If need to add GST plus CPI how do I do this. I think for yearly rent I multiply by 12 -...