The problem is that I can’t find a way of converting the logic 1’s or 0’s resulting from the IF formulas used in F13, 20 and 25 to a value where I can compare the results of the aforementioned cells and display OP, SOP or WI in C27 which corresponds to the table in columns L to O.
Any guidance on how to solve my spreadsheet problem or suggest a better method of achieving the same result would be much appreciated.
Bookmarks