Not in that way, AFAIK
But look at ToolsFormula AuditingEvaluate Formula

BTW your requirement is one reason why I always recommend to do small steps
per cell, so you can easily check all intermediate result.

In your case,

Cell1: =B2+C4
Cell2: =Cell1/D2
Cell3: =A1*Cell2

--
Kind regards,

Niek Otten

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