two columns percent in third

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I do a 3rd column of percent of two other columns without entering
=j1/k1,
=j2/k2, etc? I can do the total percent in a box at the end, but I would
like each row percent.
 
Enter

=J1/K1 in L1 and then with L1 highlighted, grab the 'fill handle' (small
square in bottom right of cell), left click on it, hold the mouse down and
drag as far as you want, Excel will look after the incrementing of the row
numbers in the formula

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
 
You must log in or register to reply here.

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

Percent column in Pivot report 1
Access My Expression Contains Wrong number of arguments 0
Want to Increase Prices by Percent 19
Curve fitting with weighted trendline 1
Using Percent 2
Calculating amount after subtracting percent 1
how can i use cond formating to colour an entire column? 2
Problem with VBA code and Range 2

Back
Top