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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Newbie Formula Question - how to get formula to repeat in each subsequent row?
On Sat, 09 Jan 2010 09:02:35 -0600, Dave Peterson
wrote: Look at the formulas in those cells again. If the formulas adjusted, but the value displayed in the cell hasn't changed, then there's a good chance you have manual recalculation set. In xl2003 menus: tools|options|calculation tab check automatic. This setting is picked up from the first workbook you open in that session. You may want to remember how to toggle it. Thanks for the reply. Recalculation was set to automatic. I seem to have it sorted out now - after I enetered the formula in the first cell I then changed the file to "hide formulae" and then just pulled the cell downwards by holding down the little "handle" on the botom rh side of the cell. This got the fomulae to repeat and change as I scrolled down. B.N. |
Reply |
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) |