Display result in a text box

[Guest]

Hi all

is there a way to display a formula result in a text box of a sheet, where I can insert some explanetory note too

thank yo
Andrea

 

[Frank Kabel]

Hi Andrea
maybe the comment function is an alternative for you. Just select the
cell with your result and goto 'Insert - Comment'

 

[Andy Brown]

See Frank's reply.

Or ... I don't know if you can do this directly, but if your formula is in
A1, then something like

="The answer is "&(A1)

in B1. Then with the text box selected, click in the formula bar, type "="
(w/out quotes), click on B1, press Enter.

HTH,
Andy