Another puzzler

[Guest]

If (1A=took 60+ minutes on 4-7 DAYS), score 1 = 3
If (1=took 30+ minutes on 4-7 DAYS, score 1 = 2
If (1 =took 30+ minutes on 1-3 DAYS) , score 1 = 1
All others should have 1 = 0
SCORE

 

[Frank Kabel]

Hi
not very clear what your issue is. Try to explain with more details

 

[Guest]

I am trying to determine the score to a series of questions.

If the answer to question 1 cell 1=took 60+ minutes on 4-7 DAYS, then cell
13 equals a score of 3
If cell 5=took 30+ minutes on 4-7 DAYS, then cell 13 equals a score of 2
If cell 9 =took 30+ minutes on 1-3 DAYS , then cell 13 equals a score of 1
All other cells in the 1-12 range then cell 13 equals a score of 0

 

[Frank Kabel]

Hi
still lack of details
- where do you enter your times values
- how do you enter DAY values?
- etc.

Please post some example data (plain text - no attachments please) and
describe based on this example your expected result
Also please use CORRECT cell references (e.g. A1, B109 and not
something like cell 13.

 

[Guest]

Thank you so much for your help. Here's how I have written the formulas for
this problem:

=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(OR(C84>1,C84<=3),1,"0")
=IF(AND(C104=0,C105=0,C106=0),0,"")