This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 82%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP3%3C/text%3E%3C/svg%3E)
Hello I am trying to use the IF(AND Formula in SharePoint List but I keep getting an error. The formula is below. =IF([Overall Rating Percentage]="<89%" , "Low Risk" , IF(AND([Overall Rating Percentage]="<79%",">=89%" , "Moderate Risk" , IF([Overall Rating Percentage]=">=79%" , "High Risk" ) ) )
Hi @Paul 316 ,
Your issue is related to SharePoint Server, I modify the tag to "office-sharepoint-server-administration".
Thank you for your support and understanding.
I finally solved the issue just removed the AND part out of the formula and this is the formula I came up with and it works. I put negative 100 for the numbers that go below 0.
=IF([Overall Rating Percentage]>89%
,"Low Risk"
,IF([Overall Rating Percentage]>79%
,"Moderate Risk"
,IF([Overall Rating Percentage]>-100%
,"High Risk")))
Hi @Paul 316 ,
What is the type of Overall Rating Percentage column? Do you want to compare the value of Overall Rating Percentage column and then mark the corresponding risk level? Please provide more information about your requirement.
This issue is caused by AND function you used, there is no error when I modify the formula like following, you could edit the formula based on it:
=IF([Overall Rating Percentage]="<89%","Low Risk",IF(AND([Overall Rating Percentage]="<79%",[Overall Rating Percentage]=">=89%"),"Moderate Risk",IF([Overall Rating Percentage]=">=79%","High Risk")))
Result:
For more information, please refer to:
---------------------------------------------------------------------------------------------------------------------------------------------------------------
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
I’m trying to get label of low risk, moderate risk, high risk based on the overall rating percentage
I tried the formula and my result is “No”. My overall rating percentage is a calculated column that renders a result after it computes its calculations.
Hi @Paul 316 ,
Please try following formula:
=IF([Overall Rating Percentage]<89%,"Low Risk",IF(AND([Overall Rating Percentage]<79%,[Overall Rating Percentage]>=89%),"Moderate Risk",IF([Overall Rating Percentage]>=79%,"High Risk")))
You could change value via modifying percentage in the red box below：
Result:
Could you tell me what your high, moderate, and low risk interval values are?
For example: High Risk: >=89%, Moderate Risk: >79% and <89%, Low Risk: <=79%.
I think your formula logic seems to be problematic, such as AND([Overall Rating Percentage]<79%,[Overall Rating Percentage]>=89%).
If it is not feasible for you, please feel free to reply.
That is correct and The Moderate Risk is the challenging one to figure out since it has in between percentages
I tried the formula it works for High Risk and Low Risk. The Moderate Risk is not working probably because it has a minimum and max limit. If you have another formula to make the Moderate Risk work I’m all ears.
Hi @Paul 316 ,
Based on High Risk: >=89%, Moderate Risk: >79% and <89%, Low Risk: <=79%,here is my formula for your reference:
=IF([Overall Rating Percentage]<=79%,"Low Risk",IF([Overall Rating Percentage]<89%,"Moderate Risk","High Risk"))