| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Multiple Array Criteria - Determine Average Result | Excel Worksheet Functions | |||
| Multiple criteria options determine which name to show as result. | Excel Worksheet Functions | |||
| Hide formula result values until all components are entered | Excel Discussion (Misc queries) | |||
| can excel draw a shape based on values entered in cells | Excel Worksheet Functions | |||
| How can I determine which cell changed as a result of a calculati. | Excel Worksheet Functions | |||
Threaded Mode
