FUNCTION IF

[Karos]

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(A2>89,"A",SI(A2>79;"B";SI(A2>69;"C";SI(A2>59;"D";"F")))) Asigna una
puntuación de una letra al primer resultado (F)
=SI(A3>89;"A";SI(A3>79;"B";SI(A3>69;"C";SI(A3>59;"D";"F")))) Asigna una
puntuación de una letra al segundo resultado (A)
=SI(A4>89;"A";SI(A4>79;"B";SI(A4>69;"C";SI(A4>59;"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;"D4";"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"

 

[Tom Ogilvy]

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