How can I add math functions to a comment?
 

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!

How can I add math functions to a comment?
 

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.

"Tom" wrote in message
...
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!

How can I add math functions to a comment?
 

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

"Andy" wrote:

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.

"Tom" wrote in message
...
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!

How can I add math functions to a comment?
 

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

"Tom" wrote in message
...
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

"Andy" wrote:

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.

"Tom" wrote in message
...
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!