using values entered in cells to determine a result in anothercel
Do you mean something like (in G24):
=IF(AND(D7="v",D8="v",D9="v",E10="v",E11="v",D12=" v"),"You win","")
Hope this helps.
Pete
On Sep 16, 4:32*pm, Jenni Ellis
wrote:
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?
|