# gst

1. ### Data entered into userform is not calculating Type mismatch?

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...
2. ### sumif formula

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...
3. ### SUMIF formula

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...
4. ### Sumifs with contains

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...
5. ### Looking for tutoring help with calculating cpi and gst

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...
6. ### adding consumer price index and gst to an amount

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 -...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back