StarOffice question

[Joel Hammer]

On Tue, Apr 27, 2004 at 10:02:38AM -0700, Condon Thomas A KPWA wrote:
> 
> Joel,
> 
> I don't have the info on the =IF(xxx) statement in front of me (i.e., how to
> parse the "else" portion), but it seems to me that you want to put the
> initial value of A into D instead, then in A put (using proper commands, of
> course):
> 
> if ( D < B ) then
> 	A = C - 100
> else
> 	A = D
> endif

I wanted to keep one account above a certain minimum by
tranferring money to it from a second account. I couldn't
get the IF statement approach to work because once the
first account was augmented the condition triggering the
reduction of the second account disappeared.  So, I just
calculated how much the first account fell each year,
stored that amount in a third cell, and then added that
amount to the first account and subtracted it from the
second account. This makes the spreadsheet bulkier but
has the advantage of working.

Joel