I think I need to be more specific. This is to compile information from
questionaires for job postings. Column E can be either yes or no and we want
a point (either zero or 2) in column F, column G can have any of the
following anwers; none (zero pts), 1-2 years (2 pts.), 3-5 years (4 pts.), 6+
years (6 pts). Then column H is for those points to be filled in. The last
two columns are repeated for several different questions. Then at the end
there is a Total column that all the points in each row would be added up. I
hope that makes more sense. Sorry, I'm not very good at explaining this.
Thanks for your trouble.
--
Rita


"Rick Rothstein (MVP - VB)" wrote:

Give this a try... assuming your data starts in Row 2, put this on Row 2 in
whatever column you want your total points in...

=IF(A2="Yes",2,0)+IF(B2=0,0,IF(B2<=2,2,IF(B2<=5,4, 6)))

and copy it down as far as necessary.

Rick


"Rita" wrote in message
...
o (Zero) = 0
1-2 = 2
3-5 = 4
6+ = 6

Yes there is another column that we want to have the sum of those columns
in
each row.

Thanks
--
Rita


"Rick Rothstein (MVP - VB)" wrote:

I think if you tell use what all the point values are for your Column 2
answers, that might be helpful.

Also, is the final answer you are looking for the sum of Column 1 and
Column
2 on a row per row basis?

Rick


"Rita" wrote in message
...
i am using Excel 2007 and XP. I really need some help with formulas to
do
the
following:

column 1: Has yes or no and we want to apply 2 points if yes and 0 if
no.
column 2: Has 4 possible answers, 0 (zero), 1-2, 3-5 or 6 plus which
each
are assigned a point value, such as 1-2 is 2 points. We need a formula
to
put
in the appropriate points.

I hope I explained this clearly. Any help is really appreciated. Thanks
so
much
--
Rita