StarOffice question

[Alma J Wetzker]

Bruce Marshall wrote:
> On Saturday 24 April 2004 07:03 pm, Joel Hammer wrote:
> 
>>This sounds like it should be easy to do in a spreadsheet, but...
>>
>>If cell A is < cell B then Subtract 100 from cell C and put it into Cell A
>>
> 
> 
> 
> In cell Axx:
> 
> =IF(Axx<Bxx;Cxx-100)
> 

I may be wrong, but...  If (Cxx-100 < Bxx), won't this thing get caught in a loop?

     -- Alma


> I think the above should do it....  but there is an error.
> 
> The problem becomes that you are trying to replace the value of A (which has 
> the above formula) with another value and that value may not fit the formula 
> anymore.  The above will work if you put the formula into something other 
> than A, B, or C....
> 
> 
> 
>>Joel
>>
>>P.S. I am planning retirement. I want to see how long
>>my money will hold out, and am looking at shifting money
>>around between categories of investments over a particular
>>time frame.