percentages

G

Guest

if i have figures in range A1 to A20 and B1 to B20 how do i easily calculate
them as percentages in C1 to C20 ?
 
G

Guest

=A1/B1 and fill down.

Or =B1/A1 and fill down. Depends what is a percentage of what?
 

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

If & sumproduct formula with text 3
+++Switch Rows & Columns 1
adding/omitting/all the values prior to todays date 2
Checkbox - Output results to a csv file 4
difference in numbers displayed as a +/- percentage 3
sumproduct with indirect 5
INDEX & MATCH functions 2
Math and action via VBA 8

Top