PDA

View Full Version : Excel Question regarding GST



Chilling_Silence
20-11-2002, 12:11 PM
I've got a column being added up, and then I want to add GST to the cell underneath, so it;s like this:
=SUM(C2:C14)
is in C15 and then in C16 I want C15 + 12.5%
How would I do that?

Cheers


Chilling_Silence

jeep
20-11-2002, 12:13 PM
just type in c16 the equation =c15*1.125

Chilling_Silence
20-11-2002, 12:25 PM
I knew it was something easy, Thanks!

Dolby Digital
20-11-2002, 02:17 PM
Hmmm..... GST whats that (its all yours isn't it!) ;)

veterannz
20-11-2002, 06:05 PM
or
=c15*(12.5%)

Elephant
20-11-2002, 09:30 PM
or
=c15*(12.5%)

Actually that won't work. If c15=100 then your formula returns 12.5

or
=c15*(12.5%)+c15 would work though. :-)

=c15*1.125 is the way I do it.

robo
20-11-2002, 09:34 PM
=Round(c15*1.125,2)

better still:
=Round(c15*(1+GST),2)
where GST is a named range with .125 in it so you can change the rate when required.

need to round to two decimal places to ensure no nasty surprises if things don't add later.

robo.

kirrie kiwi
20-11-2002, 09:57 PM
In c16 enter =sum(c15/8+c15) if you want add the gst to a total divide by 8
if you want to remove the gst from a total divide by 9
hope this helps.