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