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


--
jayoung
------------------------------------------------------------------------
jayoung's Profile: http://www.excelforum.com/member.php...o&userid=26382
View this thread: http://www.excelforum.com/showthread...hreadid=396582

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

=C1*B1/A1

should work just fine
--
Gary's Student


"jayoung" wrote:


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


--
jayoung
------------------------------------------------------------------------
jayoung's Profile: http://www.excelforum.com/member.php...o&userid=26382
View this thread: http://www.excelforum.com/showthread...hreadid=396582

Thanks You Gary for your help



Jay Young


--
jayoung
------------------------------------------------------------------------
jayoung's Profile: http://www.excelforum.com/member.php...o&userid=26382
View this thread: http://www.excelforum.com/showthread...hreadid=396582