Forum Discussion
SharePoint Calculated Column if statements with 3 arguments
I am stuck in writing a calculated column. Alist column has a range of blood alcohol content ranging from 0.00-0.500. I originally created this calculation: =IF([Breath Test Result]<=0.08,"Legal ...
TonyTone365 I missed one double quote ( " ) in my response above, try using this formula:
=IF(OR(ISBLANK([Breath Test Result]),[Breath Test Result]="N/A"),"No Results",IF(Value([Breath Test Result])<0.80,"Legal",IF(AND(Value([Breath Test Result])>0.081,Value([Breath Test Result])<=0.500),"Illegal","")))Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
The you for responding. The breath Test Result is a choice field... for example:
n/a
0.001
0.002
0.003
...
0.499
0.500
n/a
0.001
0.002
0.003
...
0.499
0.500
