IF
 

I have used the ifIF example from the Excel helpfor multiple if function. I
do have an error but I don't know what it is.
=IF(A289,"A",IF(A279,"B", IF(A269,"C",IF(A259,"D","F")))). The error is
locate at the 89,"A",IF.
Is there somebody who have an ideaa

IF
 

It works fine for me.

If you don't use comma as a list separator - you use semi colon, then it
would be:

=IF(A289;"A";IF(A279;"B"; IF(A269;"C";IF(A259;"D";"F"))))


If you don't have an english language version of excel then the IF should
probably be something else.

--
regards,
Tom Ogilvy

"François" wrote in message
...
I have used the ifIF example from the Excel helpfor multiple if function.
I
do have an error but I don't know what it is.
=IF(A289,"A",IF(A279,"B", IF(A269,"C",IF(A259,"D","F")))). The error
is
locate at the 89,"A",IF.
Is there somebody who have an ideaa