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 ,C841),1,0)))
if you meant =4 for C68
=IF(AND(C68<=7,C68=4),3,IF(AND(C84<=7,C84=4),2,I F(AND(C84<=3,C841),1,0)))
Regards,
Peo Sjoblom
"soxn4n04" wrote:
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.
|