Thread: Formula
View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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.