# Changes to a compound IF statement in Excel

F6 contains an Entity Name. F8 Contains a Date, F9 contains a  shareholder's name and F10 contains that shareholder's ownership percentage. In cell D32 I have the current formula which reads....

=IF(\$F\$9<>" ","The Estimated Value of "&\$F\$9&"'s "&TEXT(\$F\$10*100,"0.00")&"% Ownership Interest as of "&IF(\$F\$8<>"",\$F\$8,"""You must enter the Owner's Name in F9"""))

that prompts the user to enter the Owner's Name in F9.  HOWEVER, I want to expand the formula to prompt the user to enter the date in F8, if it is missing AND/OR the shareholder's name in F9, if it is missing AND/OR the shareholder's percentage of ownership in F10, if it is missing.

I have attached the Excel file I am working with.

Thanks.
LVL 1
###### Who is Participating?

x
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.

Executive Managing MemberAuthor Commented:
Attached is the file I failed to attach initially.
Fat-Bill-s-Beef-Jerky---Submission-File-
Commented:
Shouldn't the last IF condition come first and the new IF conditions too? Something like this:

=IF(\$F\$9="","""You must enter the Owner's Name in F9""",IF(\$F\$8="","""You must enter the Date in F8""",IF(\$F\$10="","""You must enter the Owner's Percentage in F10""","The Estimated Value of "&\$F\$9&"'s "&TEXT(\$F\$10*100,"0.00")&"% Ownership Interest as of "&\$F\$8)))

- tilsant

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:
I think we resolved all of the problems with

http://www.experts-exchange.com/questions/28689399/Compound-IF-statement-in-Excel.html#a40829384

But your example might work in another area.  Let me play with it later today to see if I can use and, more importantly, continue to learn.
Executive Managing MemberAuthor Commented:
Able to use your solution in another area.  Thanks for the help.
###### 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.