Hi,
try this:
="which is "&TEXT($B$24/$C$24,"0%")&" of annual income"
Regards,
KL
"gvm" wrote in message
...
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....
|