| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create specific formula | Excel Worksheet Functions | |||
| Insert rows, keep a formula? | Excel Worksheet Functions | |||
| In two workbooks, how do I create a formula that will look at a o. | Excel Discussion (Misc queries) | |||
| How do I create a formula that would allow me to subtract from a d | New Users to Excel | |||
| Create formula | Excel Worksheet Functions | |||
Threaded Mode
