starting where it is highlighted, i would like to create a formula that will give me the answer to column f (miles per tank) / column b (gallons) but it needs to change every row. is this possible?

does it make sense what i am asking?

thanks in advance!!

 

in g40, enter "=f40/b40"

then copy and paste g40 to all of the cells you want to have the calculation. excel will change the formulas so that, for example, g41 will have "=f41/b41".

 

so are you looking for:
F40/B32
F41/B32
F42/B32
F40/B33
F41/B33
F42/B33
etc...

?

 

i forgot to add that it cannot be the whole column, because i have different data above that

 

thanks!
that was easy enough.
i think i had too much coffee today

 

It won't be. Only the cells that contain the formula will display the results.

 

So you only have 3 Miles per tank cells? If so you can absolute reference by pushing F4 then copying and pasting.

=$F$40/B32
=$F$40/B33
=$F$40/B34
etc..


Edit: Damnit.. at least you find out answer

 

ya i just decided to start it on my own. the car can do it, but i wanted to keep a record. i started the sheet to see how much i spent on gas and to figure my fuel consumption.

 

even easier than copy pasting is clicking on the cell you want to 'replicate' and then clicking on the little box that appears in the bottom right hand corner when your cursor turns to a + symbol, and then just drag as far as you want...

that works for formulas, dates, times, etc...

 

how do i get rid of the #DIV/0 error?

 

Just delete it or fill in the cells referenced in the cell containing "#DIV/0" error. The reason you're getting that error is the one or both of the cells contained in the formula do not contain the data for the formula to work.

For example, if the cell contains the formula "=A1/B1", you will get an error if cell A1 or cell B1 is blank.

 

I have another question for you pros. I've got a list of movie titles in a column, and want to make it so that if you click on the title it will open firefox and query that title on imdb. is there anyway to write a formula for this? I don't want to have to go through all the titles and have to manually hyperlink them.

 

Insert --> Hyperlink


done.







edit - Here's a link for reference.. And This Right Here Is a Hyperlink.. Text with a link embeded

 

you should use a different program. its called "All My Movies" it inputs all the data right from IMDB and such forth. let me know if you want it

 

Does it run on MAC by any chance?

 

sorry

 

found me one, Thanks!

 

For row 40, if I understand what you're doing:

type the following in g40

=if(b40="","",f40/b40)

That says "If b40 is blank, then leave g40 blank, otherwise f40 divided by b40"

If you need to retain static references use the $ where needed.

Once done, copy the formula down as far as you want. When you fill in the "B" column, the formula will give a result.

 

Definitely a cleaner way to do it, good job!

 

excellent!

Thanks all!

 

I find =if(iserr(f40/b40),"",f40/b40) to be more robust.