IF formula help needed

I am getting #UNPARSEABLE from the formula below.

=IF([Risk Score]@row > 200, ".40", IF(AND([Risk Score]@row > 149.9, [Risk Score]@row <= 200), "0.35", IF(AND([Risk Score]@row < 150, [Risk Score]@row > 99.9), "0.2", IF(AND([Risk Score]@row < 100, [Risk Score]@row > 49.9), "0.03", IF([Risk Score]@row < 50, ".02"))))))))


I am trying to determine/ return the weighting factor of the risk score is. Below is the table. Not sure what is wrong in the formula above?


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!