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"))))))
Ganesh Sanap - MVP
  • 44,918
  • 21
  • 30
  • 61
Russell
  • 3
  • 1

1 Answers1

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

Ganesh Sanap - MVP
  • 44,918
  • 21
  • 30
  • 61
Lisa Chen MSFT
  • 3,267
  • 1
  • 7
  • 7
  • 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 '19 at 02: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 '19 at 02:07