|
Another puzzler
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 |
| All times are GMT +1. The time now is 12:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com