ELSE IF in calculated sharepoint field

Question

ELSE IF in calculated sharepoint field

Navigation

#1 by (1 votes)

1

How to use a ELSE IF structure 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

asked by anonymous 09.07.2015 / 17:00

1 answer

Search only a random part inside a code with select in mysql Request Validation asp.net

score 1 · Accepted Answer

For this it is necessary to nest several IF s:

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

Code ident only for understanding, I'm not sure if Sharepoint allows.

Note: Note that the separator in the Portuguese version is ; semicolon already in the English version is , .