| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Newbie Formula Question - how to get formula to repeat in each subsequent row?
I have an excel s/s which shows in one column a reading of a central
heating gas usage , In an adjacent column I want it to automatically show the increment in this gas usage reading when I enter a subsequent reading here. I have inserted the formula :- =IF(C16="","",C16-C15). This calculates the difference between C16 & C15 entries but does not do anything for an entry in C17 - the formula does not repeat as I move down the C column. I've forgoten how to do this - can someone remind me again , please ? B.N. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change print titles (rows to repeat at top) on subsequent pages | Excel Discussion (Misc queries) | |||
| Find the first & subsequent cells to contain text in & repeat | Excel Discussion (Misc queries) | |||
| Newbie Formula Question | Excel Discussion (Misc queries) | |||
| use row numbers from a list in subsequent formula | Excel Discussion (Misc queries) | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Threaded Mode
