Forum Discussion
Formula choosing next cells inconsistently
Another variant you may add named formula (reference). If you stay, for example, on C10, define it as
Be sure to use absolute reference for column and relative one for row.
With that formula could be
=(C11-CellUp)*(C11 > 0)
Well. actually that seems to have stopped working.
This was supposed to be a simple mileage tracker (for use on my cell when in the car). The idea was that I would only have to add the ending mileage (Column "C"), rather than start and stop, etc., and that mileage would be calculated in column "I".
It works except when I add more than 1 line. See highlighted cell "I51". It had the correct formula: =IF(C52>0, C52-OFFSET(C52,-1,0)0)
But when I added the next line (52) that ends up with the correct formula in I52, but I51 ends up converting to the same formula. I'm not sure why.
Any ideas?
Thanks, Ned
Another variant you may add named formula (reference). If you stay, for example, on C10, define it as
Be sure to use absolute reference for column and relative one for row.
With that formula could be
=(C11-CellUp)*(C11 > 0)- Would "Cell Up" change to the appropriate cell when a row is added? Ned
If you stay on any cell (or enter formula into any cell), CellUp returns value from the cell above. Doesn't matter where current cell is and how you change it's location, by adding rows or by other way.