excel

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

Rachel has attended:
Excel Introduction course

Excel

Is there a formula which converts values into percentages?

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

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!

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


 

Excel tip:

Editing a formula quickly

If 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

View all Excel hints and tips


Server loaded in 0.12 secs.