Formula Help

[jayoung]

I need help on how to do a formula in one cell

Price A Price B MPG A MPG B
$1.50 $1.65 27

the formula i need in MPG b goes like this

1.50/27 = 0.06 (1.65/0.06) = 29.7 I need this whole formula in the Cell
under MPG B

Thanks For any Help

Jay

 

[Guest]

If your numbers are columns A,B,C then the formula in D:

=C1*B1/A1

should work just fine

 

[jayoung]

Thanks You Gary for your help



Jay Young