Excel Formula - Conditional replacement of cells
In the attached spreadsheet I have columns "B" & "E" which is the raw data. I need to conditionally chose data from B & E to output it as in "F".
In fact I have a formula which works for the first 14 records in the excel spreadsheet shown, whose results I have in column G. I need to add to that formula (basically have a common formula, probably two IF statements, or a combination of "IF", "AND" & "OR" statements) that will work for all 18 records.
My actual spreadsheet has 1000's of such records. So, I need to evolve a common formula that I can copy in column "G".
Thanks in advance!
|