select your cell with the formula

go to the formula bar.
Highlight each cell reference in the formula successively and Do F9 on each
one. after you see the value, do escape to restore the formula. Then do
the next reference. You can select any complete subset of the formula (or
the whole formula) to evaluate it.

--
Regards,
Tom Ogilvy

"David Smith" wrote in message
...
Hi Roger,

It there any utility for that. I am just interest in seeing the reference
values temporarily in order to audit values against what is known that
they
should be.

Thank you....

David S


"Roger Govier" wrote in message
...
Hi David

=A1&" * ("&B2&" + "&C4&") / "&D2

Regards

Roger Govier


David Smith wrote:
Hello,

Is there a way (addin utilities or otherwise) to cause the formula in a
cell to display the values for the component references making up the
formula?

-i.e =A1 *(B2+C4)/D2

would display based on the cell reference values as:

=5*(4+6)/8

Thanks for your help,

David S

Hi Tom,

Thanks, that works great. How did you find out about this or is it just a
quirk of excel, can't seem to find it in the help files? Now would it be
possible to write a function that would be able to display the whole formula
showing the numeric values of each component reference all at once?

Thanks for your help....

David S



"Tom Ogilvy" wrote in message
...
select your cell with the formula

go to the formula bar.
Highlight each cell reference in the formula successively and Do F9 on
each
one. after you see the value, do escape to restore the formula. Then do
the next reference. You can select any complete subset of the formula (or
the whole formula) to evaluate it.

--
Regards,
Tom Ogilvy

"David Smith" wrote in message
...
Hi Roger,

It there any utility for that. I am just interest in seeing the reference
values temporarily in order to audit values against what is known that
they
should be.

Thank you....

David S


"Roger Govier" wrote in message
...
Hi David

=A1&" * ("&B2&" + "&C4&") / "&D2

Regards

Roger Govier


David Smith wrote:
Hello,

Is there a way (addin utilities or otherwise) to cause the formula in
a
cell to display the values for the component references making up the
formula?

-i.e =A1 *(B2+C4)/D2

would display based on the cell reference values as:

=5*(4+6)/8

Thanks for your help,

David S

Formulas can't access other formulas, so there would be no automatic way to
do that with built in formulas. You would need to write a user defined
function in VBA, but to write a generalized function would require a
function that understands all formulas in Excel - a general formula parser
so to speak.

I don't know where I learned about F9 in the formula bar; perhaps back in
xl5 or earlier when they wrote actual manuals or perhaps read it in a hits
article or in a book.

--
Regards,
Tom Ogilvy


"David Smith" wrote in message
...
Hi Tom,

Thanks, that works great. How did you find out about this or is it just a
quirk of excel, can't seem to find it in the help files? Now would it be
possible to write a function that would be able to display the whole
formula
showing the numeric values of each component reference all at once?

Thanks for your help....

David S



"Tom Ogilvy" wrote in message
...
select your cell with the formula

go to the formula bar.
Highlight each cell reference in the formula successively and Do F9 on
each
one. after you see the value, do escape to restore the formula. Then
do
the next reference. You can select any complete subset of the formula
(or
the whole formula) to evaluate it.

--
Regards,
Tom Ogilvy

"David Smith" wrote in message
...
Hi Roger,

It there any utility for that. I am just interest in seeing the
reference
values temporarily in order to audit values against what is known that
they
should be.

Thank you....

David S


"Roger Govier" wrote in message
...
Hi David

=A1&" * ("&B2&" + "&C4&") / "&D2

Regards

Roger Govier


David Smith wrote:
Hello,

Is there a way (addin utilities or otherwise) to cause the formula
in
a
cell to display the values for the component references making up
the
formula?

-i.e =A1 *(B2+C4)/D2

would display based on the cell reference values as:

=5*(4+6)/8

Thanks for your help,

David S