Re: Question on working with TEXT function



Le dimanche 20 juillet 2008 à 14:21 +0200, Berthold Höllmann a écrit :
Why is this formula invalid:

 =text(index(w!A:A;v!$A220+1;1;1),index(w!B:B;v!$A220+1;1;1);"00 00")
                                   ^
I don't understand why you use the comma just above. If you want to
separate two arguments, you need to use ';' in german locale, and in all
cases the text function takes only two arguments.

whereas 

 =text(1,1;"00 00")

 =index(w!A:A;v!$A220+1;1;1)

and

 =text(index(w!A:A;v!$A220+1;1;1);"00")

are all valid? Is this a bug im my older gnumeric version (1.7.11) or
am I doing something wrong?

Regards 
Berthold




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