Formulas
 

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

Formulas
 

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

"Aeschi" wrote:

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

Formulas
 

GST means the goods and services tax


"Barb Reinhardt" wrote:

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

"Aeschi" wrote:

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

Formulas
 

Barb

GST is a Canadian term.


Gord Dibben MS Excel MVP

On Wed, 16 May 2007 21:41:01 -0700, Teethless mama
wrote:

GST means the goods and services tax


"Barb Reinhardt" wrote:

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

"Aeschi" wrote:

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

Formulas
 

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

"Aeschi" wrote:

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