How do you display the values of variables within an Excel formula
 

I would like to be able to display the values and units of variables that
were used in a specific formula underneath the formula (i.e. show my work or
show the calculation). Is this possible? If so, how?

Is this what you mean


http://www.mvps.org/dmcritchie/excel/formula.htm

or if you mean that if the formula is let's say =AS2*B2 and you
want to see the contents of A2 and B2, select each cell in the formnula bar
and
press F9



--

Regards,

Peo Sjoblom



"curious one" <curious wrote in message
...
I would like to be able to display the values and units of variables that
were used in a specific formula underneath the formula (i.e. show my work
or
show the calculation). Is this possible? If so, how?