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

Commented:
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

Experts Exchange Solution brought to you by