View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Calculating a Percentage

BC sales tax .07, Gst .06 =.13. =(901.07/1.13)*.06 gives GSt paid

"Reegan" wrote:

Hi there,

I'm trying to separate GST from a total amount and am wondering if anyone
has a formula that can help me do this.

For example, I have a total of $901.07 and would like to know how much is
the base amount and how much is the GST. I've tried to subtract 7% but that
doesn't work out correctly.

Does anyone have any suggestion???

Thanks very much