Formulas

[Aeschi]

what is the formula for calculating GST and deducting this amount at the same
time from the total - getting the net value is what I want to achieve with
one formula

 

[Barb Reinhardt]

Your request was a bit cryptic because I'm not exactly sure what GST is, but
I'll take a guess.

Net = Gross/ (1 + tax rate)

HTH,
Barb Reinhardt

 

[Teethless mama]

GST means the goods and services tax

Your request was a bit cryptic because I'm not exactly sure what GST is, but
I'll take a guess.

Net = Gross/ (1 + tax rate)

HTH,
Barb Reinhardt

 

[Gord Dibben]

Barb

GST is a Canadian term.


Gord Dibben MS Excel MVP

 

[Michael M]

In Oz our GST is 10%

So, this will do the trick

=A1-(A1/11) will give you the original total minus GST.

HTH
Michael M