How can I add math functions to a comment?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
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
 
Back
Top