Display BOTH formula and it's result.

Hello,


I'm running Excel 2003 SP3 on a client's computer. (So please don't
answer with "you need an upgrade").

I need to display a formula and it's result. The safest way to do this without a
entering the formula in 2 places would be to place the formula in one cell, display it
as text and display the result in another cell like:

A | B | C ...
1 Formula | Result
2 =(10%*ABS((C5-D5)))+E5+(0.06*F5) | 0.00|

where the formula for B2 is "=A2"
A | B | C ...
1 Formula | Result
2 =(10%*ABS((C5-D5)))+E5+(0.06*F5) | =A2|


Is there an "Evaluate" function, then B2 could be "Evaluate(A2)"? The preference, of
course is a built in Excel function for client's ease of use; just put the solution in the
spreadsheet.

Thanks,
Merle