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



On Fri, Jan 24, 2003 at 05:24:10PM +0100, frerejacque wrote:
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?
Or where is the mistake I made in the formula

Thanks

D. FREREJACQUE

I'll make an assumption based on your email address, you are in a
locale that uses comma ',' as a decimal seperator ?  In that case
you need to use semi-colon as the argument seperator

    =if(b1;b2;b3)



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]