| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show values in formula instead of cell reference
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 -- pnorgate ------------------------------------------------------------------------ pnorgate's Profile: http://www.excelforum.com/member.php...o&userid=37753 View this thread: http://www.excelforum.com/showthread...hreadid=573365 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show values in formula instead of cell reference
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 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 Hi pnogate, Just put an apostrophe ' before the equals sign '=A1 + D4 oldchippy :) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=573365 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show values in formula instead of cell reference
Yes I tried that but that will give me only the references in that cell 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 the answer as well like 7=4+3 -- pnorgate ------------------------------------------------------------------------ pnorgate's Profile: http://www.excelforum.com/member.php...o&userid=37753 View this thread: http://www.excelforum.com/showthread...hreadid=573365 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show values in formula instead of cell reference
Thanks for that however it is still not quite what I am looking to achieve. Imagine a table with rows and columns like in a scool book but instead of just showing the answer as below I want to show the formula as 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, Pasha -- pnorgate ------------------------------------------------------------------------ pnorgate's Profile: http://www.excelforum.com/member.php...o&userid=37753 View this thread: http://www.excelforum.com/showthread...hreadid=573365 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show values in formula instead of cell reference
This does the trick
=TEXT(B1,"#")&" + "& TEXT(A2,"#")&" = "&B1+A2 Mike pnorgate wrote: Thanks for that however it is still not quite what I am looking to achieve. Imagine a table with rows and columns like in a scool book but instead of just showing the answer as below I want to show the formula as 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, Pasha -- pnorgate ------------------------------------------------------------------------ pnorgate's Profile: http://www.excelforum.com/member.php...o&userid=37753 View this thread: http://www.excelforum.com/showthread...hreadid=573365 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show values in formula instead of cell reference
Perfect!!! Many many thx to all that contributed and I hope it will prove helpful to anyone else stuck on "school work".  Pasha -- pnorgate ------------------------------------------------------------------------ pnorgate's Profile: http://www.excelforum.com/member.php...o&userid=37753 View this thread: http://www.excelforum.com/showthread...hreadid=573365 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| CELL Function: cell reference by formula | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
| numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
Linear Mode
