How would I transfer this formula from Excel to Microsoft List?

Question

I am trying to get to this outcome from Excel to Lists as the formula does not transfer over:

Which in Excel I have used this formula:

=IF(AND(E2=0,F2=0),"",IF(AND(E2=4,F2=4),"B",IF(AND(E2>=4,F2>=4),"A",IF(SUM(E2:F2)<7,"D","C"))))

Which returns A. B, C, or D depending on the previous 2 columns E & F in Excel.

Now, when I do:
=IF(AND([Criticality Factor]=0,[Uniqeness Factor]=0),"",IF(AND([Criticality Factor]=4,[Uniqeness Factor]=4),"B",IF(AND([Criticality Factor]>=4,[Uniqeness Factor]>=4),"A",IF(SUM([Criticality Factor]:[Uniqeness Factor])<7,"D","C"))))

I get an error. Can anyone coach me on what the correct way to format this is?

Answer 1

Hi @Juan ,

Per my test, you could use the following formulas:

=IF(AND([Criticality Factor]=0,[Uniqeness Factor]=0),"",IF(AND([Criticality Factor]=4,[Uniqeness Factor]=4),"B",IF(AND([Criticality Factor]>=4,[Uniqeness Factor]>=4),"A",IF((SUM([Criticality Factor],[Uniqeness Factor]))<7,"D","C"))))  

My test result:

Note: Column "Criticality Factor" and column "Uniqeness Factor" should be Number column, column Priority Level should be Calculated column

---

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.

Answer 2

Wow, thank you so much! Very helpful!