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.
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.
=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",""))