formulas

[Guest]

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

 

[Guest]

Move the decimal two spaces to the left:

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

Dave

 

[Guest]

Move the decimal two spaces to the left:

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

Dave

 

[PCLIVE]

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

 

[PCLIVE]

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

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[RagDyer]

No brainer to calculate the *tax*:

=100*8.16%

 

[RagDyer]

No brainer to calculate the *tax*:

=100*8.16%