formatting a sentence with functions

J

Josh Craig

Hi all,
I have this formula in a cell:

="market share is 100% until 2005 then reduces by "&(1-'Takeup'!L104)&" each
year."

The value in 'Takeup'!L104 is in percentage format but when I put it in the
above sentence it becomes a number format.

In other words, L104 contains: 15% but the above function gives me:
0.149654384.

Is there anyway to get it to actually display as a percentage in the result
of the above function?

Thanks for your help.

Josh
 
J

Jacob Skaria

Try the below which uses TEXT()

="market share is 100% until 2005 then reduces by " & TEXT(L104,"#%") &" each
year."

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top