Hello,
taking over a workbook for someone and I am trying to simplify their formula. Attached
From what I see, these are using a nest IF(AND(OR(NOT with search and ISNUMBER
I do not know that all of these are needed. Essentially, I would like to consolidate all columns (X-AB) to one nested IFS statement in column W.
From what I can see the the variables with change, so need a IFS that supports multiple outputs.
I started and IFS to test it out on the attached.
On Excel 2016
Bookmarks