Formula

[Guest]

I need to determine one answer for a question that has several possible
scenarios.

=IF(OR(C68=4,C68<=7),3,"0")
=IF(OR(C84=4,C84<=7),2,"0")
=IF(OR(C84>1,C84<=3),1,"0")
If none of the above are true, then the score would be 0.

 

[Guest]

What if C68 is 5 and C84 is 5, has C68 precedence?
then you can use

=IF(C68<=7,3,IF(AND(C84<=7,C84>=4),2,IF(AND(C84<=3,C84>1),1,0)))

if you meant =>4 for C68

=IF(AND(C68<=7,C68>=4),3,IF(AND(C84<=7,C84>=4),2,IF(AND(C84<=3,C84>1),1,0)))


Regards,

Peo Sjoblom