How can I add math functions to a comment?

[Guest]

I would like to display some data in a rollover effect so that I don't have
to duplicate the data in another table cell which would clutter up the
report.

For instance, I want to show "=B2-B3" in a comment or other rollover effect.

Is this possible?
Thanks!

 

[Guest]

Hi

You could use Data/Validation to have an 'input message'. This will display
when the cell is selected - regardless of whether you actually us validation
on the cell.

Andy.

 

[Guest]

The input message still doesn't allow math functions. It's just a straight
output what what you put in it. Unless I'm doing this wrong. If I put
"=B5+B6", then I just get a literal output of that equation, not the results
of the equation like you can in a cell.

So, I'm basically trying to see if the same functions that exist in a cell
can exist in a comment, input message or similar.

Thanks!
Tom

 

[Guest]

Ah, right. I don't know of a way to produce the result of a sum. Sorry.
Andy.