# gst

1. ### 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...
2. ### 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...
3. ### 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...
4. ### 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...
5. ### 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 -...

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...