Formula Help

J

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
 
G

Gary's Student

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

=C1*B1/A1

should work just fine
 
Top