game_over Posted July 1, 2011 Share Posted July 1, 2011 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 More sharing options...
0 Mippie Posted July 1, 2011 Share Posted July 1, 2011 This should work: " =0.20*A1 " Where A1 is the total. Link to comment Share on other sites More sharing options...
0 lawtai Posted July 1, 2011 Share Posted July 1, 2011 You should just need to do <=0.2*47.76> to get 9.552 Link to comment Share on other sites More sharing options...
0 AbandonedTrolley Posted July 1, 2011 Share Posted July 1, 2011 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 More sharing options...
0 Teebor Posted July 1, 2011 Share Posted July 1, 2011 47.76 * 0.20 = 9.552 Unless I'm doing something wildly wrong?? Link to comment Share on other sites More sharing options...
0 game_over Posted July 1, 2011 Author Share Posted July 1, 2011 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 More sharing options...
0 harveyhanson Posted July 1, 2011 Share Posted July 1, 2011 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 More sharing options...
0 S_Herbie Posted July 15, 2011 Share Posted July 15, 2011 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 More sharing options...
Question
game_over
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