View Single Post
  #1   Report Post  
TM
 
Posts: n/a
Default 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