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(C841,C84<=3),1,"0")
If none of the above are true, then the score would be 0.