I'm trying to shorten a calcuation by using a single formula in one cell as oppose to my current method of multiple calculations over multiple cells.

Sample attached:

I use 3 hidden columns to display my Risk level then another formula to put them in one column.

The formula I'm trying to use generates a #VALUE! error and I can't figure out why.

New Formula:

=OR(IF(AND(A2=0,B2=0),"High Risk",""),IF(AND(A2=0,B2>=1),"Medium Risk",""),IF(AND(A2>=1,B2>=1),"Low Risk",""))

Sample attached:

I use 3 hidden columns to display my Risk level then another formula to put them in one column.

The formula I'm trying to use generates a #VALUE! error and I can't figure out why.

New Formula:

=OR(IF(AND(A2=0,B2=0),"High Risk",""),IF(AND(A2=0,B2>=1),"Medium Risk",""),IF(AND(A2>=1,B2>=1),"Low Risk",""))

## Comment