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.




"dbcruzin" wrote:

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.