I’m trying to put together a spreadsheet that calculates rates based on certain answers to yes or no questions. In the example that I’ve attached, there are two columns that can have a Y or N answer. If the first column is Y, then there should be a Y automatically placed in column 3.
Any Yes answer in column 1 gets an automatic Y in column 3. The problem is if there is a No in column 1 and a Yes in column 2. This is a valid exception and should also get an automatic yes in column 3 (see yellow row). Any No response in Column 1 gets an automatic N in column 3.
This spreadsheet may eventually have 200 rows.
Any help in getting this to work will be greatly appreciated.