Re: did IF exists in gnumeric 1.0.5 (Red Hat Distribution)

[Tino Meinen <a t meinen chello nl>]

On Fri, 2003-01-24 at 17:24, frerejacque wrote:

> Given four cells:
> B1,B2,B3,B4  
> B1 and B2 receiving credit and debit,
> B3 a current amount = A3+B1-B2 (it works)
> I wanted to have in B4 the non-null cell of B1 and B2 (one only contain
> a value)
> so I put in B4   =IF (B1,B2,B1)
> which is flagged as in error, as are
>       =IF (B1==0,B2,B1) and 
>       =IF (B1=0,B2,B1)
>
> So my question :
>       is the (shortly) documented IF implemented in gnumeric?
Looking at the IF documentation, you should use:

B4=IF(B1,B1,B2)

(or maybe B4=IF(B1;B1;B2) if you use the french locale)

For safety, you could just press the button in the toolbar labeled f(x)
and fill in the appropriate cells.

--Tino Meinen