The following formula is being used in column B: =IF(A2="CHANGE_GENERIC_OBJECT",IF(C2=FALSE,IF(ISBLANK(E2),"LOA","WK LOC"),"POSITION/ORG"))
So the outcome is either POSITION/ORG, LOA, WK LOC OR FALSE. Instead of FALSE I'd like the return to equal whatever the text is in column A. For example, if A2 shows TERMINATE, I'd like the text TERMINATE to appear in B2 instead of FALSE.
Any recommendations on how I can change this formula?