IF Formula Assistance

Ron Bayes
Ron Bayes used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Analyst Assistant
Commented:
Ron

Try this.

=IF(A2="CHANGE_GENERIC_OBJECT",IF(C2=FALSE,IF(ISBLANK(E2),"LOA","WK LOC"),"POSITION/ORG"), A2)

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial