Thread: IF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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