B1 contains 100

C1 =$B1*.25 returns 25

D1 =$B1*.50 returns 50

and so on


Gord Dibben MS Excel MVP

On Mon, 21 Dec 2009 07:45:01 -0800, 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.