How do I make column C a percentage of column B

D

dbcruzin

I need to calculate different percentages for fixed numbers I have in column
B. How do I make column C a percentage of B, column D a different percentage
of B, and so on.
 
E

Eduardo

Hi,
not pretty sure what you want, you need column C to show percentage of B
based on a column B total ? if yes do

=B1$B$100

B100 = cell with the total
dopy formula down

if this is not what you were looking for please give an example thanks
 
T

trip_to_tokyo

Worked example:-

1. In cell B 1 enter:-

100

2. In cell C 1 enter:-

50

3. In cell D 1 enter:-

=(C1/B1)

The result of this formula will show as:-

50%

(Make sure that cell D 1 is formatted as follows:-

- single right hand click in cell D 1

- from the options that are launched select Format Cells (by clicking on it)

- Number tab

- Category: (make sure that this is set to Percentage and then hit OK)).

Apply the above to your situation and you should come up with what you want.

Please hit Yes if my comments have helped.

Thanks.
 
G

Gord Dibben

B1 contains 100

C1 =$B1*.25 returns 25

D1 =$B1*.50 returns 50

and so on


Gord Dibben MS Excel MVP
 

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

Top