If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to create formula to divide two rows autoaatically
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
|
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
"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 -- |
#9
|
|||
|
|||
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 -- |
#10
|
|||
|
|||
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 |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can inserted rows automatically include existing worksheet formula | tgdavis | General Discussion | 2 | September 20th, 2005 09:08 PM |
How do I create a formula to copy and paste between workbooks? | NickyHarris69 | General Discussion | 2 | June 15th, 2005 09:23 AM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
How do I create a formula that picks the last entry | Dave | Worksheet Functions | 3 | December 9th, 2003 11:02 AM |
Lookup Formula | Scott Frickman | Worksheet Functions | 4 | September 21st, 2003 07:45 PM |