FUNCTION IF
 

Hello, i have found a possible bug in the spanish help of the function if in
Office 2003 Professional.

In the bottom of the help page the example have this:

=SI(A289,"A",SI(A279;"B";SI(A269;"C";SI(A259;" D";"F")))) Asigna una
puntuación de una letra al primer resultado (F)
=SI(A389;"A";SI(A379;"B";SI(A369;"C";SI(A359;" D";"F")))) Asigna una
puntuación de una letra al segundo resultado (A)
=SI(A489;"A";SI(A479;"B";SI(A469;"C";SI(A459;" D";"F")))) Asigna una
puntuación de una letra al tercer resultado (C)

The first example don´t work in my excel page, but with the next command it
work well:

=SI(C9=1;"D1";SI(C9=2;"D2";SI(C9=3;"D3";SI(C9=4;"D 4";"F"))))

See that de difference it´s all elements with ";" not with "," as occurs
with the 2 others examples, ¿why this difference?

See also: "Función si"

FUNCTION IF
 

They should be separated by ";". I suspect it is a typo.

--
Regards,
Tom Ogilvy


"Karos" wrote:

Hello, i have found a possible bug in the spanish help of the function if in
Office 2003 Professional.

In the bottom of the help page the example have this:

=SI(A289,"A",SI(A279;"B";SI(A269;"C";SI(A259;" D";"F")))) Asigna una
puntuación de una letra al primer resultado (F)
=SI(A389;"A";SI(A379;"B";SI(A369;"C";SI(A359;" D";"F")))) Asigna una
puntuación de una letra al segundo resultado (A)
=SI(A489;"A";SI(A479;"B";SI(A469;"C";SI(A459;" D";"F")))) Asigna una
puntuación de una letra al tercer resultado (C)

The first example don´t work in my excel page, but with the next command it
work well:

=SI(C9=1;"D1";SI(C9=2;"D2";SI(C9=3;"D3";SI(C9=4;"D 4";"F"))))

See that de difference it´s all elements with ";" not with "," as occurs
with the 2 others examples, ¿why this difference?

See also: "Función si"