Link to home
Start Free TrialLog in
Avatar of Ron Bayes
Ron Bayes

asked on

IF Formula Assistance

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!
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ron Bayes
Ron Bayes

ASKER

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