IF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top