How to show actual sum

  • Thread starter Thread starter wk495292
  • Start date Start date
W

wk495292

Any help will be appreciated, I am trying to display the actua
calculation along with the answer. In excel you enter a formula in
cell and that gives you the answer I would also like to display th
working out.

Thank
 
Thanks, I have tried this and it just shows the cell reference ie. b2
need it to show the actual value.

Thank
 
Sounds like this could be messy to maintain but here goes:

=B1 & " + " & B2 & " = " & B1+B2

You do realise that you can't do any calculations using the values in these
cells ? Effectively, they are text values.

Regards

Trevor
 
I am new to Excel and trying to self teach myself so forgive me if thi
is the longwinded or the wrong way but i thought I would have a bash a
trying to solve problems.
Could you use
=CONCATENATE("A1+B1=",A1+B1) as a formula in C1
If you want to show the sum of A1+B1 in C1. This should give yo
A1+B1=3 shown in C
 
Are you looking to show the display value and the
formula.

You have your cell showing the formatted value, simply
place a user defined function (UDF) to show the actual
formula in use as in C1: below.

See my web page for the UDF of GetFormula
http://www.mvps.org/dmcritchie/excel/formula.htm
(see yellow box at top of page if not familiar with UDF or macros.
C1 show the formula alongside the value in B1,
but can be anywhere you want it.

A1: 14 displays 14
B1: =3+4+A1 displays 21
C1: =GetFormula(B1) displays =3+4+A1

I see no reason to show both in the same cell but that
seems to be how others have interpreted your question:
D1: = A1 & " using " & GetFormula(B1)
to display: 21 using =3+4+A1
 
Back
Top