Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / August 2006

Tip: Looking for answers? Try searching our database.

Show values in formula instead of cell reference

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
pnorgate - 19 Aug 2006 10:52 GMT
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

Signature

pnorgate

oldchippy - 19 Aug 2006 11:02 GMT
pnorgate Wrote:
> 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
[quoted text clipped - 8 lines]
>
> Pasha
Hi pnogate,

Just put an apostrophe ' before the equals sign

'=A1 + D4

oldchippy :
pnorgate - 19 Aug 2006 11:27 GMT
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+
Don Guillett - 19 Aug 2006 13:07 GMT
="h1+6="&VALUE(H1+6)

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>
> For the life of me I don't know how to change a formula in a cell i.e.
[quoted text clipped - 9 lines]
>
> Pasha
pnorgate - 20 Aug 2006 08:01 GMT
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
Mike - 20 Aug 2006 09:15 GMT
This does the trick

=TEXT(B1,"#")&" + "& TEXT(A2,"#")&" = "&B1+A2

Mike

> Thanks for that however it is still not quite what I am looking to
> achieve.
[quoted text clipped - 25 lines]
> pnorgate's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37753
> View this thread: http://www.excelforum.com/showthread.php?threadid=573365
pnorgate - 20 Aug 2006 09:31 GMT
Perfect!!!

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

Pash
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.