Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: HELP - SCORE BOARD

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Aylesbury, UK
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi can someone please help me, I'm a bit of a novice with excel and need to put a questionnaire with 12 questions into a spreadsheet.

    The answers to the questions are scored (they range from 5 - very happy, to 1 very unhappy).

    At the end of each sheet I need a mark out of 100 for what each person's feelings are, in order to highlight any unhappy customers.

    Any help would be greatly appreciated.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I know this sounds anally retentive, but 12 questions with a maximum of 5 points each, would make the maximum total 60? Do you mean that you want that split into a percentage, so that each customer has a % of how happy they are?

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    79
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Come on Joe, don't be so cruel to the lady, they can't always see things as clearly as the male population.

    But hey yes it was a bit anally retentive.

    Roy

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I didn't mean to be cruel, I just needed some clarification. I'm sorry if it came across that way Nicola, unfortunately you couldn't see my face when I was typing it. I was smiling and petting a dog, and kissing a baby's forehead, and speaking in a very agreeable voice. if any of you had been here, you probably would have fallen in love with me, I was being that charming.

    But anyway, all I needed to know was if you needed the answer expressed as a percentage? It's just that 12 questions with a maximum of five points each comes to 60, so I didn't quite understand what that 'out of 100' bit meant.

    You should have seen me then, while I typed that bit I was feeding an orphan

  5. #5
    New Member
    Join Date
    Apr 2002
    Location
    Aylesbury, UK
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yes I did mean as a percentage - sorry for being so utterly stupid!!! (does this mean you may be abl;e to help?)
    Hope you are enjoying the orphan!
    x

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    All righty, that's no problem then. If you want, you can Private Message me your email address or I'll send you mine and you can either send me an example of what your questionnaire looks like, and I'll do it for you and send it back with an explanation,OR I can send you a mock one but it wont look anything like what you're working on

    Up to you. I'll send you my email address through Private Message and we can go from there.

    Ramone the orphan says hello by the way. Ow! He bit me! Still, that's what you get from being brought up by a wolf I guess

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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