I am trying to assign a value to letters (Y,N). In some columns I need Y to equal "10 and others I need it to equal "3". Same with N. When all "Y's" and "N's" are entered I need to add them up to get a score. Any help would be helpful as I am a rookie when it comes to this sort of thing so if you could break it down "big Bird" style for me it would help a bunch. Thanks.

Just to clarify, I have a "yes or no" answer sheet with about 15 questions. I would like the "Y" in question 1 to have a greater value than a "Y" in say question 7. The same goes with the "N" answers. Then I would like to add up all the totals to get a final number such as 56.

I may need a little more clarification. Let's take question 1 where Y = 10. Does N also have a value for that question? If so, you could use a nested IF statement for each question as follows: Assume your first question is in A1 and Y (worth 10) or N (worth 5) will be placed in B1. In C1 enter: =IF(B1="Y",10,IF(B1="N",5,"")) For the question in A2, you might have: =IF(B2="Y",7,IF(B2="N",3,"")) In other words, change the values for Y and N in the formula for each question. Once you have all the values in column C simply sum the values. A more elegant way to do this would be to use a VLOOKUP table. You could put the same formula in every cell in column C which would lookup the value for Y or N based on values you put in a table stored elsewhere in the sheet. If you ever wanted to change the point vlaue for a Y or N for a given question, you would simply change the value in the table and not have to alter any formulae. An example of the formula you might use follows. I can explain it in more detail if you are interested in this method. =IF(B1="Y",VLOOKUP(ROW(),$G$1:$I$12,2,1),IF(B1="N",VLOOKUP(ROW(),$G$1:$IH$12,3,1),""))

You will want to use either an IF statement or a nested IF formula. For example: IF(A2="Y",9,1) Meaning If A2 shows a "Y" then enter the value to be "9" else "1". So if yes is the answer then the score will be 9 and if No then the score will be 1. Can you provide specific values you are looking for? Explaining nested if statements is too much to ask without specifics. Bryan

I was sitting on that for a while but I see we both require additional information. Bryan

The form I am trying to make will be something like: Y N N/A Are there signs? Is the house locked? Does it have a pool? Is the pool secured? Has the grass been mowed? And so on, They will either put an "X" "Y" or "N" in the column for each question ( I really don't care if I use "X's" or " Y's and N's") But the "N" answer for whether or not the pool is secured needs to have more value ( or more weight) than a "N" for whether the grass was mowed since it is a safety hazard. Once it is all done I want to get a total score of 1-100 with 100 being a perfect hose and 0 being one that is completly messed up. Hope this helps.

re: IF(A2="Y",9,1) We should also point out that without using a nested IF, the OP will get a 9 for a Y and a 1 for anything else, including a blank. This is just a clarification for the OP, not a correction of your answer. You went as simple as possible, and I understand why. Perhaps by reading both posts, the difference will be evident to the OP.