Show values in formula instead of cell reference

P

pnorgate

For the life of me I don't know how to change a formula in a cell i.e.
=A1 + D4 which will give a final value to show the actual values for A1
& D4 i.e. 2 + 4 = 6 and show this equation in the cell itself. Is this
possible?

It's for a school project for my son who's 10yo.

Can anyone help please?

Cheers from downunder - Melbourne.

Pasha
 
O

oldchippy

pnorgate said:
For the life of me I don't know how to change a formula in a cell i.e
=A1 + D4 which will give a final value to show the actual values for A
& D4 i.e. 2 + 4 = 6 and show this equation in the cell itself. Is thi
possible?

It's for a school project for my son who's 10yo.

Can anyone help please?

Cheers from downunder - Melbourne.

Pasha
Click to expand...
Hi pnogate,

Just put an apostrophe ' before the equals sign

'=A1 + D4

oldchippy :
 
P

pnorgate

Yes I tried that but that will give me only the references in that cel
like =G4+F3 but what I would like to show is the actual value of G4
F3 in the formula so it would read either =4+3 or better still show th
answer as well like 7=4+
 
P

pnorgate

Thanks for that however it is still not quite what I am looking t
achieve.
Imagine a table with rows and columns like in a scool book but instea
of just showing the answer as below I want to show the formula a
values - see second table below what I mean.


Table 1
+ 1 2 3
1 2 3 4
2 3 4 5
3 4 5 6


Table 2
+ 1 2 3
1 1+1=2 1+2=3 1+3=4
2 2+1=3 2+2=4 2+3=5
3 3+1=4 3+2=5 3+3=6


Can anyone help please?

Cheers,

Pash
 
P

pnorgate

Perfect!!!

Many many thx to all that contributed and I hope it will prove helpfu
to anyone else stuck on "school work".:eek:

Pash
 
Top