Display BOTH formula and it's result.

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
One of the method would be have client download an addon called "moreFunc". It is free. You can download it from https://download.cnet.com/Morefunc/3000-2077_4-10423159.html

In that there is a function called "FORMULATEXT". That will give the formula in a cell
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month