if function

[delmac]

using this function for F11 i get "high risk" instead of "very high risk"
when the total is 290 because the statement is true and therefore I should
get the 2nd argument.
If i change it around then i get the wrong answer for F!).
ANy ideas
=IF(H11<1,"Standard Risk",IF(H11<6,"Medium Risk",IF(H11<10,"High
Risk",IF(H11<22,"Very High Risk",IF(H11<66,"Medium Risk",IF(H11<100,"High
Risk",IF(H11<142,"Very High Risk",IF(H11<300,"High Risk","Very High
Risk"))))))))

 

[Eduardo]

Hi,
If the total is 290 the answer is High Risk as per your formula no Very High
Risk, see the last part or your formula

IF(H11<300,"High Risk","Very High

Risk"))))))))

290 is less than 300 so High Risk