Re: Question on working with TEXT function

[bhoel despammed com (Berthold Höllmann)]

Jean Bréfort <jean brefort normalesup org> writes:

> 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.

I hoped text would accept an arbitrary number of values to be
formatted. I now use concatenate to get the wanted result.

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

I misinterpretd the outcome of this.

> >  
> >
> >  =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

Thank You
Berthold

-- 
A: Weil es die Lesbarkeit des Textes verschlechtert.
F: Warum ist TOFU so schlimm?
A: TOFU
F: Was ist das größte Ärgernis im Usenet?

Attachment: pgpLs2FbXrQDG.pgp
Description: PGP signature