Repeat formula in new rows

Giganews Newsgroups
Subject: Repeat formula in new rows
Posted by:  ~~~AAA~~~ (ba…@one.com)
Date: Sun, 13 Jul 2008

I have created a simple spread sheet to keep track of finances.  Each day I
want to enter a stock price at the beginning of a new row and then have
about 8 columns adjust their amounts in the new row.  When I enter a new
stock price at the beginning of a new line and press enter, only two of the
8 columns tabulate and produce new amounts.

The two columns that do act correctly have these formulas on line 14 for
example:

F14 has: =50000*B14
J14 has: =F14-187492.97

Some of the ones that do not adjust and stay blank have these formulas on
line 13:

C13 has: =B13-B12 but there is nothing in C14
D13 has: =(C13/B12)*100 but again nothing in D14
G13 has: =F13-F12 but nothing in G14

* All the columns have the same formulas repeated at least for 9 rows before
the non-working areas.
* Extend data range formats and formulas is checked.

Replies