StarOffice question

[Bruce Marshall]

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 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.
>
>
>
> _______________________________________________
> Linux-users mailing list
> Linux-users at smtp.linux-sxs.org
> Unsubscribe/Suspend/Etc ->
> http://smtp.linux-sxs.org/mailman/listinfo/linux-users

-- 
+----------------------------------------------------------------------------+
+ Bruce S. Marshall  bmarsh at bmarsh.com  Bellaire, MI         04/24/04 19:59  +
+----------------------------------------------------------------------------+
" It's frustrating when you know all the answers, but nobody bothers to
   ask you the questions."