Formula Help
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 |
All times are GMT +1. The time now is 08:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com