1 Attachment(s)
can someone help with an easy formula?
I've attached the spread sheet in question. I have successfully completed one formula but i'm struggling with two more. If you open the file and look on the Net Promoter Score tab. Where the student numbers are listed and the numbers 0-6 are I have managed to enter the correct formula so that if on the Course Feedback (L&B & BSI) tab on question 12 on every students answer if 0-6 is inputted a 1 appears on the corresponding students number on the Net Promoter Score tab.That formula being =IF('Course Feedback (L&B & BSI)'!D17<=6,1,0)
Now I want to do the same if the student puts 7 or 8 and then another for the 9 and 10 area. For the life of me I just cant seem to foud how to add it to the formula for the 7+8 and 9+10.
Hope you can understand what im getting at. Can anyone help.
Re: can someone help with an easy formula?
=IF('Course Feedback (L&B & BSI)'!E17=7,1,IF('Course Feedback (L&B & BSI)'!E17=8,1,0))
and
=IF('Course Feedback (L&B & BSI)'!E17=9,1,IF('Course Feedback (L&B & BSI)'!E17=10,1,0))
???
Re: can someone help with an easy formula?
drop me a pm we can have a chat ill get you a solution
Re: can someone help with an easy formula?
The same as above, but with offset to make life easier (starting @ H2).
=IF(OFFSET('Course Feedback (L&B & BSI)'!$D$15,0,ROW()-2)=9,1,IF(OFFSET('Course Feedback (L&B & BSI)'!$D$15,0,ROW()-2)=10,1,0))
Re: can someone help with an easy formula?
=IF(OR('Course Feedback (L&B & BSI)'!D17=7,'Course Feedback (L&B & BSI)'!D17=8),1,0)
AND
=IF(OR('Course Feedback (L&B & BSI)'!D17=9,'Course Feedback (L&B & BSI)'!D17=10),1,0)