0

I would like to create a calculated column to return a text value based on a score in another column but I cant get the syntax correct. can someone help?

Low = 0 - 35
Med = 36 - 70
High = 71- 105
V high = 106 +
  • 1
    Write your Formula in Excel first, SharePoint is 1:1 for this simple formula – Danny '365CSI' Engelman May 23 '16 at 11:27
0
=IF(AND(Col>=0,Col<=35),"Low",
IF(AND(Col>=36,Col<=70),"Med",
IF(AND(Col>=71,Col<=105),"High",
IF(AND(Col>10),"V High",""))))

Consider Col is your column name from which you want value to be evaluated .Try this Formula

Added extra condition, if value is less than 0 this column will return blank value

  • Thank you for your help, definitely worth putting into excel first. – Louise13 May 23 '16 at 14:11
1

Overly complex to use AND

=IF( Col<36 
     ,"Low"
     ,IF( Col<71 
          ,"Med",
          IF( Col<106 
              ,"High",
              ,"Very High"
            )
        )
    )

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.