Need help with Excel formula

I have a cell which reads as follows;

=IF(E9<>"","High, Low and Average Adjusted Net Values of "&E9&"'s "&TEXT(E10*100,"0.00")&"% Ownership Interest Based on ","You must enter a name in B10")

Which yields,

High, Low and Average Adjusted Net Values of John Smith's 51.00% Ownership Interest Based on                                                             

At the end of the above (....Based  on....) I want to add the phrase POSSIBLE ESTIMATES if the Value of W10 is 1, ACTUAL VALUES if the value of W10 is 2 or PROBABLE OUTCOMES if the value of W10 is 3.
LVL 1
Bill GoldenExecutive Managing MemberAsked:
Who is Participating?
 
Rgonzo1971Commented:
Hi,

pls try

=IF(E9<>"","High, Low and Average Adjusted Net Values of "&E9&"'s "&TEXT(E10,"0.00%")&" Ownership Interest Based on "&CHOOSE(W10,"POSSIBLE ESTIMATES", "ACTUAL VALUES", "PROBABLE OUTCOMES"),"You must enter a name in B10")

EDIT corrected Pct

Regards
0
 
Bill GoldenExecutive Managing MemberAuthor Commented:
Excellent.  Learned something new in the process.
0
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.

All Courses

From novice to tech pro — start learning today.