Gord

Thanks

I only do not know how to round this figure up to what I need check my
previous post.

Tom

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Whoops!

Ignore.

Was working from the wrong end.

Jim has you sorted out I see.

Gord

On Fri, 01 Apr 2005 17:26:43 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Thomas

Buy a new calculator.

660.17 * .075 = 49.51

Using Excel or the Calculator from Acessories


Gord Dibben Excel MVP

On Fri, 1 Apr 2005 20:13:13 -0500, "Thomas Grassi"

wrote:

I have Office XP PRofessional Excel 2002 SP3

I am trying to calculate sales tax in my spreadsheet and cannot come up
with
the correct amount.

I48 = $660.17
A48 = 7.5%

G48 has =I48*(1-A48)

The result is $610.66

H48 is the sales tax result

=SUM(I48-G48)

The result is $49.51

I have a manual calculator that does sales tax and it does not match

$660.17
7.5%
$46.05 sales tax
Total minus sales tax is $614.12


Any ideas?

Thanks

Tom