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

[Gary's Student]

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
>
>

[jayoung]

Thanks You Gary for your help



Jay Young