ELSE IF in calculated Sharepoint field

Asked

Viewed 390 times

1

How to use a structure ELSE IF in a calculated Sharepoint field, for example:

= IF([Nota]>=80,"A")
  ELSEIF([Nota]>=70,"B")
  ELSEIF([Nota]>50,"C")
  ELSEIF([Nota]>=30,"D")
  ELSE("E")
sharepoint

1 answer

1


For this it is necessary to nest several IFs:

=IF([Nota]>=80;
   "A";
   IF([Nota]>=70;
      "B";
      IF([Nota]>50;
         "C";
         IF([Nota]>=30;
            "D";
            "E"
         )
      )
   )
)

Code idented just for understanding, I’m not sure if Sharepoint allows.

Obs.: Note that the separator in the English version is ; a semicolon, in the English version is a ,.

Browser other questions tagged sharepoint

You are not signed in. Login or sign up in order to post.