We help IT Professionals succeed at work.

IF Formula Assistance

62 Views
Last Modified: 2018-11-07
Hello,

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?

Thanks!
Comment
Watch Question

Analyst Assistant
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
Got it - I was missing the comma at the end.  Thanks!