This may be a shot in the dark and will be a long formula, but here it goes:

I have multiple columns that I want to condense to one. Therefore, I want
column B to show current status of a work order based on the following:

If column V is blank, column B shows €œOpen€�.

If column V is filled (date) and column J K, column B shows €œComplete/No€�.
If column J <= K, column B shows €œComplete/Yes€�.

Now even though column V is filled, once column AE is filled (date) and
column J K, column B shows €œClosed/No€�. If column J <= K, column B shows
€œClosed/Yes€�.

If column AC and AE are filled (date), column B shows €œClosed/BER€�.

If column AD and AE are filled (date), column B shows €œCanceled€�.