Excel Calculation
Biff,
Perfect! Thanks for you help and quick response. It is very much
appreciated.
Zee
"T. Valko" wrote:
sales tax amount divided by sales tax rate:
=13/0.065
Result = 200
--
Biff
Microsoft Excel MVP
"Zee" wrote in message
...
Hello,
I hope someone can help me. I am trying to create a forumula for
calculating TAXABLE SALE AMOUNT.
I will know 2 things.
1. That the sales tax rate is 6.5%
2. The SALES TAX AMOUNT.
For instance if the SALES TAX AMOUNT is $13.00 and the Sales Tax Rate is
6.5% the "caluclated TAXABLE SALE AMOUNT " would be $200.00.
I hope this is a acceptable question for this forum. Hopefully one of you
math geninus can help me out.
|