Making Percentages

  • Thread starter creating a reference list
  • Start date
C

creating a reference list

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.
 
T

Toppers

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
 
R

Roger Govier

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

Roger Govier


"creating a reference list"
 
Top