using values entered in cells to determine a result in another
That helps, but what if i then wanted to compare two columns
i.e.
D E G
Yes No
7 q1 v
8 q2 v
9 q3 v
10
11 Result here
so, if column D shows v's in D7, D9 and column E shows a v in cell E8, then
the result I would need to return in G11, "your a winner", however if the
entries were altered in any way (i.e. D8, D9, E7 all contain v's), then the
result would contain something like "try again"
Will the countif function and adding the results help achieve this?
"Bob Phillips" wrote:
=IF(COUNTIF(D7:D9,"v")+COUNTIF(E10:E11,"v")=5,"You r a winner","")
--
__________________________________
HTH
Bob
"Jenni Ellis" wrote in message
...
apologies in advance if I am not being clear.
I am trying to create a question/answer spreadsheet. The answers are
selected from a "yes" column and "no" column, using a random alphabetical
value (v for example).
What I need to do is use various combinations of v's in the yes and no
columns to determine an overall answer. i.e. if cells d7, d8, d9, e10,
e11,
d12 contain "v", then another cell e.g. g24 would show the result "your a
winner". If the combination was to alter then the results would change
accordingly. Any suggestions?
|