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