0

I'm quite new to this, could anyone point out why my calculated field isn't working

Im trying to use a matrix to output a value of critical, high, medium or low

The field Im using is ImpUrg_Total, this is my current failure

=IF(ImpUrg_Total<2,"Critical",IF(AND([ImpUrg_Total]>=2,[ImpUrg_Total]<4,"High",IF(AND([ImpUrg_Total]>=4,[ImpUrg_Total]<9,"Medium",IF([ImpUrg_Total]=>9,"Low"))))))
0

Use your formula like the following:

=IF(ImpUrg_Total<2,"Critical",IF(AND([ImpUrg_Total]>=2,[ImpUrg_Total]<4),"High",IF(AND([ImpUrg_Total]>=4,[ImpUrg_Total]<9),"Medium",IF([ImpUrg_Total]=>9,"Low"))))

Similar issue post for your reference:

  1. SharePoint 2013 calculated column adding multiple if statement

  2. Calculated Column with Nested IF statments

  • Thanks for your help, it still didn't like it but was a lot closer, I changed it slightly to add in <13 as it will never be 13 or more so it worked like this – Russell Oct 25 at 2:07
  • =IF(ImpUrg_Total<2,"Critical",IF(AND(ImpUrg_Total>=2,ImpUrg_Total<4),"High",IF(AND(ImpUrg_Total>=4,ImpUrg_Total<9),"Medium",IF(AND(ImpUrg_Total>=9,ImpUrg_Total<13),"Low")))) – Russell Oct 25 at 2:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.