98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2003
Wed 7 May 2008, 16:35Delegate Rachel said...
Rachel has attended:
Excel Introduction course
Excel
Is there a formula which converts values into percentages?
Wed 7 May 2008, 20:16Trainer Tracy said...
RE: Excel
Hi Rachel,
There is a percentage button which converts decimals into percentages, does that help? For example .2 press the % button turns into 20%
Tracy
Fri 9 May 2008, 11:36Delegate Rachel said...
RE: Excel
Not quite, say for example if I did a survey of 68 people and 22 people said "yes", is there a way on Excel i could convert the 22 out of 68 people into a percentage?
Many thanks!
Mon 12 May 2008, 01:29Trainer Tracy said...
RE: Excel
OK fool proof method
A1 = 68
B1 = 22
solution = (B1/A1)*100
But no I don't think there is a button for this you would have to use a formula
Tracy
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Editing a formula quicklyIf you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key |
