|
how to create formula to divide two rows autoaatically
Is there any way to setup a sheet or create a formula so that it will divide
the data in column A by Column B anytime the data is entered and put it into columnC ? What I am trying to do is create a spreadsheet for calculating fuel MPG. So I have columns as miles, gallons and the calculation as MPG. What I want to do is anytime a value is entered into miles and gallons, to calculate mpg and put it into that respective cell. Is there any way I can do this ? Thanks -- Tony |
Tony, in Column C, type the formula =sum(a1/b1). This should give you the
result you are looking for. Hope this helps "TM" wrote: Is there any way to setup a sheet or create a formula so that it will divide the data in column A by Column B anytime the data is entered and put it into columnC ? What I am trying to do is create a spreadsheet for calculating fuel MPG. So I have columns as miles, gallons and the calculation as MPG. What I want to do is anytime a value is entered into miles and gallons, to calculate mpg and put it into that respective cell. Is there any way I can do this ? Thanks -- Tony |
That only works for one cell in that particular row.
I want to be able to enter the miles and gallons in any row and have it automatically calculate mpg for that row, Here is some sample data: Miles Gall MPG 200 10 20 That formula works great but there seems to be no way to have it use that formula all the way down the sheet for any value entered into miles-column, gallons-column and have it calculate mpg Can this be done ? -- Tony "Lern2Ern" wrote in message ... Tony, in Column C, type the formula =sum(a1/b1). This should give you the result you are looking for. Hope this helps "TM" wrote: Is there any way to setup a sheet or create a formula so that it will divide the data in column A by Column B anytime the data is entered and put it into columnC ? What I am trying to do is create a spreadsheet for calculating fuel MPG. So I have columns as miles, gallons and the calculation as MPG. What I want to do is anytime a value is entered into miles and gallons, to calculate mpg and put it into that respective cell. Is there any way I can do this ? Thanks -- Tony |
Try copying the formula down from the starting cell, say in C1.
Drag the fill handle (the black square at the bottom right corner of C1) down as far as there is data in cols A and B (or you could also just double-click on the fill handle) And you could even copy down ahead to cater for expected data in cols A and B, if you want. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "TM" wrote in message ... That only works for one cell in that particular row. I want to be able to enter the miles and gallons in any row and have it automatically calculate mpg for that row, Here is some sample data: Miles Gall MPG 200 10 20 That formula works great but there seems to be no way to have it use that formula all the way down the sheet for any value entered into miles-column, gallons-column and have it calculate mpg Can this be done ? -- Tony |
|
Copy the formula down the column, and every time you enter data in Column A
and Column B, you'll get an instant answer in Column C. After you enter the formula =A1/B1 In C1, click in C1 again. You'll see a small black square in the lower right corner of this selected cell. When you hover the cursor over this square, it'll change from a fat white cross to a skinny black cross. At that point, click and drag the cursor down the column, which is copying the formula down Column C. You'll notice that the formula changes, as to cell addresses, so that Column C will then calculate Column A and Column B on *every* row. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "TM" wrote in message ... That only works for one cell in that particular row. I want to be able to enter the miles and gallons in any row and have it automatically calculate mpg for that row, Here is some sample data: Miles Gall MPG 200 10 20 That formula works great but there seems to be no way to have it use that formula all the way down the sheet for any value entered into miles-column, gallons-column and have it calculate mpg Can this be done ? -- Tony "Lern2Ern" wrote in message ... Tony, in Column C, type the formula =sum(a1/b1). This should give you the result you are looking for. Hope this helps "TM" wrote: Is there any way to setup a sheet or create a formula so that it will divide the data in column A by Column B anytime the data is entered and put it into columnC ? What I am trying to do is create a spreadsheet for calculating fuel MPG. So I have columns as miles, gallons and the calculation as MPG. What I want to do is anytime a value is entered into miles and gallons, to calculate mpg and put it into that respective cell. Is there any way I can do this ? Thanks -- Tony |
If you fill column C with:
=IF(B1=0,"",A1/B1) and copy this down the entries will "look"automatic. That is, the C cells will aprear blank until you enter numbers in column A and B -- Gary's Student "TM" wrote: Is there any way to setup a sheet or create a formula so that it will divide the data in column A by Column B anytime the data is entered and put it into columnC ? What I am trying to do is create a spreadsheet for calculating fuel MPG. So I have columns as miles, gallons and the calculation as MPG. What I want to do is anytime a value is entered into miles and gallons, to calculate mpg and put it into that respective cell. Is there any way I can do this ? Thanks -- Tony |
That works pretty good if the miles is zero it does not give a divide by
zero error. But what about if gallons is zero ? Can I look to see if both are zero ? Thanks -- Tony "Gary's Student" wrote in message ... If you fill column C with: =IF(B1=0,"",A1/B1) and copy this down the entries will "look"automatic. That is, the C cells will aprear blank until you enter numbers in column A and B -- Gary's Student "TM" wrote: Is there any way to setup a sheet or create a formula so that it will divide the data in column A by Column B anytime the data is entered and put it into columnC ? What I am trying to do is create a spreadsheet for calculating fuel MPG. So I have columns as miles, gallons and the calculation as MPG. What I want to do is anytime a value is entered into miles and gallons, to calculate mpg and put it into that respective cell. Is there any way I can do this ? Thanks -- Tony |
"TM" wrote:
.... Can I look to see if both are zero ? One way .. We could use in the starting cell: =IF(OR(A1=0,B1=0),"",A1/B1) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
That works like a charm, awesome thanks
-- Tony "Max" wrote in message ... "TM" wrote: ... Can I look to see if both are zero ? One way .. We could use in the starting cell: =IF(OR(A1=0,B1=0),"",A1/B1) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
You're welcome !
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "TM" wrote in message ... That works like a charm, awesome thanks -- Tony |
I got a lot of my begginer help on this site... cool they teach you by making a, time sheet, Invoice and cheek book from scratch on Windows media Player very cool www.MDOTutorials.com -- Route2391 ------------------------------------------------------------------------ Route2391's Profile: http://www.excelforum.com/member.php...o&userid=26774 View this thread: http://www.excelforum.com/showthread...hreadid=398845 |
| All times are GMT +1. The time now is 07:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com