Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
yes or no results spreadsheet
I have a very simple excel table, 3 columns, many rows.
ColA = response 1 (y or n) ColB = response 2 (y or n) ColC = Include (y or n) What I want ColC to produce is as follows: If ColA and ColB are both y, then ColC is y If ColA and ColB are both n, then ColC is n If ColA and ColB disagree (one y, one n), then ColC is n I need a formula so I dont have to go through each row (there are 1000 or so) and enter each response in ColC by hand. Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generating Simple Reports From A Master Spreadsheet | Excel Worksheet Functions | |||
How do I insert a 2-3 page Excel spreadsheet as an object in MS Wo | Excel Discussion (Misc queries) | |||
Spreadsheet shortcuts not working | Setting up and Configuration of Excel | |||
Spreadsheet merging problems | Excel Worksheet Functions | |||
calculating results in formulas | Excel Discussion (Misc queries) |