View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jenni Ellis Jenni Ellis is offline
external usenet poster
 
Posts: 3
Default using values entered in cells to determine a result in another cel

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?