tax formula

[jesseok]

I am having trouble getting the tax formula. I need to figure a .0925% tax
rate on the line above the tax line. Really simple, just not getting it.
Thanks, Jeff

 

[AltaEgo]

Your problem is not obvious. Is it that you type 0925% and see something
different? If so,

1) Click on the affected cells
2) Click Format, Cells...
3) Choose percentage
4) Change the number of decimal places.

Irrespective of what you see in the cells, Excel will apply the figure
completed in the formula bar or copied from elsewhere.

 

[jesseok]

It is that I am trying to use a .0925% tax rate to figure the tax amount.
Example line 45 is Sub-total line, line 46 is Tax line....I need the
formula to figure the tax on the amount in line 45

 

[Don Guillett]

=a2*.0925

 

[jesseok]

Thank you, I got it Thanks again

=a2*.0925
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[AltaEgo]

The recommended way is to use a named cell for your tax rate.

To do this, click on the cell whare your tax rate is stored. Name the cell.
To do this, Immediately above the 'A' at the top of column A is the name
box. Overwrite the cell address showing with a meaningful name (e.g.
TaxRate).

You tax payable calculation at A46 would be

= A45*TaxRate

To figure a tax inclusive amount (i.e. without showing a separate tax
amount)

= A45 * (1+TaxRate)


Without the named cell you need to do a fixed reference to your tax rate
cell. Presuming your tax rate is in cell A2 (and only in A2),

= A45*$A$2

Drag or copy the formula to other required cells.