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.