• 0

Work out percentage in Excel/Numbers


Question

Probably simple but its not showing correct results

20% of ?47.76 is ?9.534 - i want the part in bold, i am calculating how much tax i owe from my profit.

but when i do amount/total = percentage i'm getting ?2.38

Link to comment
Share on other sites

7 answers to this question

Recommended Posts

  • 0

Probably simple but its not showing correct results

20% of ?47.76 is ?9.534 - i want the part in bold, i am calculating how much tax i owe from my profit.

but when i do amount/total = percentage i'm getting ?2.38

Try using this, I made it for the people in work for working out VAT but works with any amount and rate, just change the appropriate.

=47.76*(20/100)

VAT Calc.zip

Link to comment
Share on other sites

  • 0

It works :)

Try using this, I made it for the people in work for working out VAT but works with any amount and rate, just change the appropriate.

thanks for this, very helpful.

Link to comment
Share on other sites

  • 0

In cell A1 put your percent

In cell B1 put 47.76

In cell C1 enter =SUM(A1*B1)

Change A1 and C1 to currency

Done

Link to comment
Share on other sites

  • 0

In cell A1 put your percent

In cell B1 put 47.76

In cell C1 enter =SUM(A1*B1)

Change A1 and C1 to currency

Done

You don't need the sum part - just A1*B1...

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.