Help Please with a percentage problem
Hi I have created a s/sheet for a fruit machine I have and would like to work
out the payout percentage:- A2 = money in $100 and A3 = money out $78 What formula would i use to state the payout percentage is 78% Thanks |
Help Please with a percentage problem
Try...
=A3/A2 ....and format the cell as 'Percentage'. Hope this helps! In article <56aa4ced9ce92@uwe, "kyleuk via OfficeKB.com" <u15338@uwe wrote: Hi I have created a s/sheet for a fruit machine I have and would like to work out the payout percentage:- A2 = money in $100 and A3 = money out $78 What formula would i use to state the payout percentage is 78% Thanks |
Help Please with a percentage problem
Hi
Either =A3/A2*100 or =A3/A2 and format cell as Percentage (click the "%" sign on the Format toolbar. Regards Roger Govier kyleuk via OfficeKB.com wrote: Hi I have created a s/sheet for a fruit machine I have and would like to work out the payout percentage:- A2 = money in $100 and A3 = money out $78 What formula would i use to state the payout percentage is 78% Thanks |
Help Please with a percentage problem
Thanks both Domenic & Roger its works great.
Roger Govier wrote: Hi Either =A3/A2*100 or =A3/A2 and format cell as Percentage (click the "%" sign on the Format toolbar. Regards Roger Govier Hi I have created a s/sheet for a fruit machine I have and would like to work out the payout percentage:- [quoted text clipped - 5 lines] Thanks |
All times are GMT +1. The time now is 05:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com