Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Corey
 
Posts: n/a
Default Equations with numbers and letter values

I am creating a performance chart for employees to fill
out. Below is an example of a set of questions they need
to complete, with a possible answer to each. My
spreadsheet is being designed to calculate a points system
on multiple categories

1. How many appointments did you have? "2"
2. How many new appointments did you set? "1"
3. Did you follow up with active client groups, not yet
rented? "Y"
4. Have you made collection calls to clients that owe
money? "N"
5. Have you reviewed and replied to all your emails? "Y"

I need a formula that will add up all the numeric answers,
but also set an individual value for each question that
has a "Y" or "N" entry. So question 3 may be a +3 towards
the total of "Y" but question 5 may only be a +1 towards
the total if "Y" or a -3 if "N"

please help!

Much Thanks!
Corey
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

You have a response at your other post in this newsgroup.

Corey wrote:

I am creating a performance chart for employees to fill
out. Below is an example of a set of questions they need
to complete, with a possible answer to each. My
spreadsheet is being designed to calculate a points system
on multiple categories

1. How many appointments did you have? "2"
2. How many new appointments did you set? "1"
3. Did you follow up with active client groups, not yet
rented? "Y"
4. Have you made collection calls to clients that owe
money? "N"
5. Have you reviewed and replied to all your emails? "Y"

I need a formula that will add up all the numeric answers,
but also set an individual value for each question that
has a "Y" or "N" entry. So question 3 may be a +3 towards
the total of "Y" but question 5 may only be a +1 towards
the total if "Y" or a -3 if "N"

please help!

Much Thanks!
Corey


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Alphabetical list of Numbers are not correct! scott Excel Discussion (Misc queries) 3 February 2nd 05 05:39 PM
Replace Letter "E" with Letter "C" for 200 Different Sums in a Col Katherine Excel Worksheet Functions 1 January 21st 05 03:53 AM
Sorting when some numbers have a text suffix confused on the tundra Excel Discussion (Misc queries) 5 December 18th 04 11:19 PM
letter Validation Maltenrazer Excel Worksheet Functions 2 November 6th 04 06:00 PM
generating Unique ID numbers for students Maltenrazer Excel Worksheet Functions 2 November 6th 04 01:32 AM


All times are GMT +1. The time now is 04:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"