if function

  • Thread starter Thread starter delmac
  • Start date Start date
D

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"))))))))
 
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"))))))))
Click to expand...
290 is less than 300 so High Risk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Statements 3
Mulitple if function 2
IF function question 9
Focus problem?? 3
Transposing Multiple Cell References to Multiple Values (NOT total 7
Transposing Multiple Cell references as Multiple Values 1
Nesting IF functions within one Formula 11
Count If.....help 6

Back
Top