How do I show formulas (in values) for the calculation?

  • Thread starter Thread starter fuc847
  • Start date Start date
F

fuc847

when i'm doing caluclations in excel, i want to "show my work". I dont
mean just showing the formula (eg. =A10 + B20, you can do this if you
copy/paste the function in the cell). But instead, say if the value in
A10 is 1 and B20 is 2, i want it to show "=1+2" in the cell.

I understand if I type in the cell: '=A10& "+" B20, it'll show what i
want. but it'll be veyr troublesome. I need a more automated easier
way, almost as easy as say copy and pasting as a special option.

I need this so that show my work on the worksheet.

Is there possibly a macro/add-in for this>?

thanks
 
If you are looking for a worksheet solution and only the values either
constants or formulas in A10 and B20 change then you could use
="=" & VALUE(A10) & "+" & VALUE(B20)

Another example with columns D & E

Displayed -- personal.xls!GetFormula(D3)
1 D3: 1
20 D4: =20*D3
21 D5: =D3+D4
=1+20 D6: =VALUE(D3) & "+" & VALUE(D4)

The user defined function in E4 showing the formula in D4 can be seen in
http://www.mvps.org/dmcritchie/excel/formula.htm#getformulad
 
fuc847 -

When a cell containing a formula is selected so that the formula shows in
the formula bar, you can select portions of the formula in the formula bar
(by click-and-drag or double-click) and then press F9 to evaluate that
selected portion of the formula.

This isn't what you want because it's not displayed in the cell, and you may
already be aware of this feature. But it might be close enough to assist
you.

- Mike
www.mikemiddleton.com
 
Back
Top