% Calculation in a column

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

Columns B + C have numerical data. I want column C to
calculate a percentage. this percentage will have B in
the numerator and sum of B+C in the denominator. Would
like this percentage to automatically be calculated on
each line entry. I suspect that this is very elementary
but nobody ever called me the brightest star in the sky.
 
Hi Don
If you have data in B and C, in Cell D put =B/(B+C)
When it's done, copy down as far as you like.
Regards
Michael
 
Use another col to calculate, say col D

Otherwise you'll hit a circular reference error

Try in D2: =B2/SUM(B2:C2)

Format D2 as percentage

Copy D2 down as many rows as there is data in cols B and C
 
Back
Top