Need help writing formulas in excel using ratios
 

Help !!!
I wish to auto calculate $ values using ratios. Basically, i would like to
have a cell reference were you can enter the desired ratio. The using this
cell reference have a formula which auto calculates the required $ value
based on the ratio entered.

Can anyone help me write this formula ?

Cheers,
Peter...