 # Thread: can someone help with an easy formula?

1. ## 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.  Reply With Quote

2. ## 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))

???  Reply With Quote

3. ## Re: can someone help with an easy formula?

drop me a pm we can have a chat ill get you a solution  Reply With Quote

4. ## 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))  Reply With Quote

5. ## 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)  Reply With Quote

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•