two columns percent in third

C

Common Rock

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.
 
N

Nick Hodge

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
 
Top