Thread: Formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default 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