Hi,

Use the formula

="which is "&ROUND(($B$24/$C$24)*100,0)&"% of
annual income"

If you want the percentage to be rounded off to a different decimal,
make the necessary correction in the round formula.

For eg. if you want % in two decimal use

="which is "&ROUND(($B$24/$C$24)*100,2)&"% of
annual income"



Regards

Govind.



gvm wrote:
I need a worksheet function so that a cell will display "which is 17% of
annual income" where 17% is actually the value that results from a formula
involving two cell references, eg $b$24/$c$24. Is this possible? Any help
will be much appreciated, cheers....