Close

Results 1 to 5 of 5
  1. #1
    DF Jedi satzzz's Avatar
    Join Date
    Oct 2000
    Location
    Here
    Posts
    2,808
    Thanks
    170
    Thanked:        655
    Karma Level
    451

    Help 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.
    Attached Files Attached Files
    Just use enough water to cover your vegetables,the same goes for when you're having a bath....

  2. #2
    DF PlaYa neilcritc's Avatar
    Join Date
    Dec 2003
    Location
    Rochdale
    Posts
    818
    Thanks
    71
    Thanked:        42
    Karma Level
    280

    Default 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))

    ???

    Thanks to neilcritc

    satzzz (25th July 2014) 


  3. #3
    DF PlaYa neilcritc's Avatar
    Join Date
    Dec 2003
    Location
    Rochdale
    Posts
    818
    Thanks
    71
    Thanked:        42
    Karma Level
    280

    Default Re: can someone help with an easy formula?

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

    Thanks to neilcritc

    satzzz (25th July 2014) 


  4. #4
    DF PlaYa pattikins's Avatar
    Join Date
    Jul 2001
    Location
    manchester
    Posts
    795
    Thanks
    251
    Thanked:        82
    Karma Level
    314

    Default 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))

    Thanks to pattikins

    satzzz (28th July 2014) 


  5. #5
    DF Jedi akimba's Avatar
    Join Date
    Jun 2006
    Location
    UK
    Posts
    3,019
    Thanks
    1,152
    Thanked:        836
    Karma Level
    336

    Default 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)

    Thanks to akimba

    satzzz (28th July 2014) 


Similar Threads

  1. Formula One to return to BBC TV
    By Nibb in forum General Sports
    Replies: 24
    Last Post: 4th April 2008, 03:57 PM
  2. France easy easy easy
    By diablos in forum Football
    Replies: 13
    Last Post: 8th October 2006, 05:10 PM
  3. Rhinos destroy the Bulls (EASY, EASY, EASY)
    By Tattooed Freak in forum General Sports
    Replies: 5
    Last Post: 25th March 2005, 08:11 PM
  4. formula oneski ?
    By 4me2 in forum General Sports
    Replies: 0
    Last Post: 6th January 2004, 02:53 PM
  5. Formula One 2003
    By tagy in forum Sony Consoles
    Replies: 0
    Last Post: 5th July 2003, 02:11 AM

Social Networking Bookmarks

Posting Permissions

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