formulas
 

To you pros out there this may sound stupid. If taxes are 8.160% what
formula would I use to get the exact amount. Not sure where to put the
decimal point.

Thanks

formulas
 

Move the decimal two spaces to the left:

$100*.0816, for example, equals $100 * 8.16%

Dave
--
Brevity is the soul of wit.


"Snoozie" wrote:

To you pros out there this may sound stupid. If taxes are 8.160% what
formula would I use to get the exact amount. Not sure where to put the
decimal point.

Thanks

formulas
 

This will give you the amount of tax to be applied to an amount in A1.
=A1*0.0816

This will give you the total amount including tax.
=A1+(A1*0.0816 )

HTH,
Paul


"Snoozie" wrote in message
...
To you pros out there this may sound stupid. If taxes are 8.160% what
formula would I use to get the exact amount. Not sure where to put the
decimal point.

Thanks

formulas
 

"PCLIVE" wrote in message
...

This will give you the total amount including tax.
=A1+(A1*0.0816 )

or just

=A1*1.0816
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"PCLIVE" wrote in message
...
This will give you the amount of tax to be applied to an amount in A1.
=A1*0.0816

This will give you the total amount including tax.
=A1+(A1*0.0816 )

HTH,
Paul


"Snoozie" wrote in message
...
To you pros out there this may sound stupid. If taxes are 8.160% what
formula would I use to get the exact amount. Not sure where to put the
decimal point.

Thanks

formulas
 

No brainer to calculate the *tax*:

=100*8.16%
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Snoozie" wrote in message
...
To you pros out there this may sound stupid. If taxes are 8.160% what
formula would I use to get the exact amount. Not sure where to put the
decimal point.

Thanks