Help Please with a percentage problem

  • Thread starter Thread starter kyleuk via OfficeKB.com
  • Start date Start date
K

kyleuk via OfficeKB.com

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
 
Hi

Either
=A3/A2*100
or
=A3/A2 and format cell as Percentage (click the "%" sign on the Format toolbar.

Regards

Roger Govier
 
Thanks both Domenic & Roger its works great.

Roger said:
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:-
Click to expand...
[quoted text clipped - 5 lines]
Thanks
Click to expand...
Click to expand...
 
Back
Top