Change percentages to numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way in Excel to change percentages, i.e. sales tax [ex. 5%], to
the currency equivalation of the sales tax?
 
type 0.05 and format as currency, I don't see any purpose doing this
though, if you want the amount of sales tax just multiply with 5% =A1*5%
or =A1*(1+5%) for total price and format result as currency

--
Regards,

Peo Sjoblom

(No private emails please)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quarterly tax percentages 12
Calculating percentage growth rate from a cumulative figure 4
Excel Calculation 4
A What-if scenario changing one figure to work out another 4
If calculations 3
sales tax 2
If then formulas 4
Simple Question, Calculating Discounts 3

Back
Top