Calculating Sales Tax with the Paste Function

[Alex]

This may be very basic stuff - but I am stumped.

I am trying to use the paste function to calculate sales tax in a
spreadsheet.

I have the total sales figure in E2 and the tax rate in LA County is
8.25% -
I am using the "Percentrank" function and I think the definition of
the terms is not what I think it is -

this is how far I get:
=PERCENTRANK(E2,,8.25%)

E2 is the array or field I want to use as the base and then I don't
know what "rank" is - and then I think my final number is the
percentage rate of 8.25% or they list it as 'significance' -

HELP!
Alex

 

[Peo Sjoblom]

Try

=E2*8.25%

 

[kkknie]

I think Percentrank is for something entirely different (ranking ho
high a value is in a group of values). If all you want to do i
calculate sales tax based on a base price. Just use:

=A1*0.0825

assuming the base price is in A1. You can also round to the neares
penny using

=ROUND(A1*0.0825,2)

 

[Peo Sjoblom]

Sorry, you said you had the total amount in E2 and you want to know how much
of that is ST
with 8.25% use

=E2-(E2/1.0825)