ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula (https://www.excelbanter.com/excel-worksheet-functions/7437-formula.html)

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.

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.