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
