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(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F")))). The error is
locate at the 89,"A",IF.
Is there somebody who have an ideaa

It works fine for me.

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

=IF(A2>89;"A";IF(A2>79;"B"; IF(A2>69;"C";IF(A2>59;"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" <[email protected]> wrote in message
news:[email protected]...
> 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(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F")))). The error
is
> locate at the 89,"A",IF.
> Is there somebody who have an ideaa
>
>