# Compound IF statement in Excel

I have the following formula in C13:

=IF(O13<>""," "&AA14&"'s Name: ","Please enter the Name of the Member/Owner/Partner/Shareholder ▬▬►  ")

I want to expand the formula to, IF O13<>"" and AA14 <>""
IF BOTH ARE TRUE, " "&AA14&"'s Name: "
IF TRUE AND FALSE, "Member/Owner/Partner/Shareholder Name: "
IF FALSE AND TRUE, "Please enter the "&AA14&" Name ▬▬►  "
IF FALSE AND FALES, ""Please enter Member's, Owner's, Partner's or Shareholder's Name ▬▬►  "

The spreadsheet is huge, so I have attached a small, but functioning applicable portion.
SAMPLE-CalcXLM-Report-Snippet-21.xls
LVL 1
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
Hi

Copy the below

change C2= O13  and D2 = AA14

=IF(AND(C2<>"",D2<>""),""&AA14&"s Name: ",IF(C2<>"","Member/Owner/Partner/Shareholder Name: ",IF(D2<>"","Please enter the "&AA14&" Name ▬▬►","Please enter Member's, Owner's, Partner's or Shareholder's Name ▬▬►")))
0
Commented:
Hi

I change it for you

=IF(AND(O13<>"",AA14<>""),""&AA14&"s Name: ",IF(O13<>"","Member/Owner/Partner/Shareholder Name: ",IF(AA14<>"","Please enter the "&AA14&" Name ▬▬►","Please enter Member's, Owner's, Partner's or Shareholder's Name ▬▬►")))
0

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Executive Managing MemberAuthor Commented:
Thank you.  That works great!
0
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.