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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks