StarOffice: Changing the value of a cell from another cell

[Tim Wunder]

On Saturday 03 April 2004 8:18 pm, someone claiming to be Joel Hammer wrote:
> I seem to recall in Quatropro there was a way to change the value of a
> cell based on the value in a different cell. For example, something like
> this in cell A3.
>
> =IF(A1=0;B1=Zero;B1=NotZero)
>
> I don't think this was the syntax but you get the idea.  Is there a way
> to do this in StarOffice?
>

Would this work:
In cell B1 place "=A3", assigning to cell B1 the contents of A3.
Then in A3 place "=if(a1=0;"Zero";"NotZero")"

The question is, why wouldn't you just want to put the =if statement in cell 
b1?

FWIW, I can't seem to find a way to assign a value to a field name in OOo, 
which appears to be what you're after.

Regards, 
Tim

-- 
Fedora Core 1, Kernel 2.4.22-1.2174.nptl,  KDE 3.2.1, Xfree86 4.3.0
 13:15:01  up 28 days,  4:18,  2 users,  load average: 0.14, 0.23, 0.49
It's what you learn after you know it all that counts