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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"soxn4n04" schrieb im Newsbeitrag
...

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

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" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

"soxn4n04" schrieb im Newsbeitrag
...

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

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.


--
Regards
Frank Kabel
Frankfurt, Germany

"soxn4n04" schrieb im Newsbeitrag
...
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" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

"soxn4n04" schrieb im
Newsbeitrag
...

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

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

"Frank Kabel" wrote:

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.


--
Regards
Frank Kabel
Frankfurt, Germany

"soxn4n04" schrieb im Newsbeitrag
...
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" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

"soxn4n04" schrieb im
Newsbeitrag
...

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