Formula: Return Pro Rata (proportionate) Value

[Willz]

Hello OzGrid

Hoping someone may be able to help me here, i have the following table and am trying to work out the formula to put in column C to pro rata the value of cell A1 against the values in column B1:5 so it appears as i've shown below....

 A         B          C
600      10000      400
  .        5000       200 
  .          0          0
  .          0          0
  .          0          0

Many thanks for your help.
Willz

[johnccc]

Hi,

VBasically you need the A1 part of the formula to read A$1$

Your post is however a little misleading, you need two numbers to provide a ration and one more number to apply that ratio to. You only seem to have two numbers??

John

[pangolin]

put this formula in cell C1 and copy

=$A$1*(B1/SUM($B$1:$B$5))