Calculating GST at 15% - Excel Page 2 / 9

little_egypt, Oct 28, 10:56pm
What rg says; leave the fraction as 15/115 or 15/100 and it's immediately obvious. Reduce it to 3/23 or 3/20 and most people will be scratching their head for a few minutes trying to figure out where that ratio comes from. Remember that half the population have below-average skills in maths.. and I don't think the average is all that high either.

cherise11, Oct 28, 11:15pm
I think the OP was asking for the EXCEL formula, something like this =A1 * (1 + .15)?

badcam, Oct 28, 11:26pm
It wouldn't surprise me if there were people who don't realise that you can use a pen and paper (or your head) to do Math. "You mean you can do this without a calculator or a computer ?!?"

drcspy, Oct 28, 11:40pm
yep stillbloody simple tho

cherise11, Oct 28, 11:46pm
racheal77 IRD have a free downloadable cashbook here here select Record Keeping/Other Books/Cash Book/Sample Cah Book (you will need a flash player). In Excel click on the Formulas ribbon, highlight GST Received or GST Paid then in the Formula Auditing section click Show Formulas. I hope this helps.

cherise11, Oct 28, 11:48pm
I'm using MS Office 2007 btw

damon3, Oct 29, 1:00am
wtf ? Decimals can't represent a third as accurately as 1/3

radiowaves, Oct 29, 1:15am
Yeah.Some people have problems with basic maths.Others struggle with basic English!

ross1970, Oct 29, 1:20am
I see what you're getting at but they can:3?

mumz31, Oct 29, 1:25am
Hi there.I have been reading some of the feedback you have been getting, and I am a little annoyed to be honest.Don't we have this community message board for a reason??Who are all these people that feel they can judge your question?I am assuming they know everything there is to know.It would be a sad day when they needed to ask a question they thought was difficult and got shot down by someone who knew the answer.Chill out people.

damon3, Oct 29, 1:29am
# 36- welcome to the internet...

ross1970, Oct 29, 1:37am

johnf_456, Oct 29, 1:40am
+1 , times 1.15

johnf_456, Oct 29, 2:22am
Are you digging at me?

cybertao, Oct 29, 2:25am
Fixed that for you.

johnf_456, Oct 29, 2:27am
LOL my calculation is right, depends what you want to calculate in gst. Add on, gst amount...

honeybean, Oct 29, 2:39am
talk about turning a simple question in to a bun fight.
poster 1:
If you want to extract the GST amount in excel - just divide by
eg 115.00divided by 7.66666 = 15.00 which is the gst content of

biker_69, Oct 29, 2:48am
That's what they said.

biker_69, Oct 29, 2:50am
Anyone who wants to confuse themselves with 3/23 or 1/9 or 8/9 is welcome to do so. But I do percentages the proper way using decimals. 15.23568% of $80 = 0.1523568 x 80. Simple and accurate.

johnf_456, Oct 29, 2:53am
+1 Easy peasy.

biggal, Oct 29, 3:24am
Racheal Its quite common to get your head bitten off by the wankers on here. Sorry it had to be you this time. Hope you can get your head backon straight.

widoolz, Oct 29, 3:29am
hahahaha definitely some funny s^%$@! going on here!!!
The initial question reads like a Certificate in Business Administration & Computing Course question...hmmm

radiowaves, Oct 29, 3:29am
Incorrect.The IRD stipulate that you must use a minimum of 8 decimal places.

rgtrading, Oct 29, 5:04am
typo, I meant decimals. However, 0.15 and 1.15 are a lot easier to remember for most people than 3/23 surely.

biker_69, Oct 29, 5:55am

Share this thread

Buy me a coffee :)Buy me a coffee :)