Making Percentages
 

Thanks. I now have 40%-95% across the top and 100-520 down the side. Now
does anyone know the formula for percentage. I want to be able to see what
ex. 85% of 320.

Making Percentages
 

85% of 320 is 320*0.85.

Dave
--
Brevity is the soul of wit.


"creating a reference list" wrote:

Thanks. I now have 40%-95% across the top and 100-520 down the side. Now
does anyone know the formula for percentage. I want to be able to see what
ex. 85% of 320.

Making Percentages
 

Multiply the row/column intersection

If B1=40% (formatted as %) and A2=100 then in B2 put:

=B$1*$A2

Copy across and down and you will have your matrix.

HTH


"creating a reference list" wrote:

Thanks. I now have 40%-95% across the top and 100-520 down the side. Now
does anyone know the formula for percentage. I want to be able to see what
ex. 85% of 320.

Making Percentages
 

Hi
Try entering in cell B2
=$A2*B$1
Copy across and down to fill the matrix
--
Regards

Roger Govier


"creating a reference list"
m wrote in message
...
Thanks. I now have 40%-95% across the top and 100-520 down the side.
Now
does anyone know the formula for percentage. I want to be able to see
what
ex. 85% of 320.