converting data into percentages quickly?

S

showsomeidnow

hi. i have a list of pupil data in column A. The total number of
pupils in the class is 30 and i wish to convert the data into a
percentage but i have to do this individually for each cell. for
example (in column B)
=15/30
=10/30
=5/30 etc etc.

is there an easier way to do this? thanks all.
 
A

Arvi Laanemets

Hi

Enter 30 into some free cell, and copy this cell;
Select the range with data you want to convert, and PasteSpecial>Divide;
Format the converted range as percentage;
[Clear value 30 entered at start]
 
G

Guest

if cell your cell are like this

A B
1 15 =A1/30

2 10 =A2/30

3 5 =A3/30


If you enter in B1 =A1/30, all you have to do is copy from:B1 to:B2 and B3.
Excel will automatically change the row number for you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Percentages 2
If statement with multiple criteria and multiple results 3
percentages of counts 1
Basic question - how to calculate a cumulative percentage 2
Pivot table question: How to display total and percent for data simultaneouly 1
How to create percentages for the combined rows? 1
Calculating Percentages in Pivot Table 1
Pivot Table? ID, Date, Value sorting 4

Top