| 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 |
| 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) | |||
Threaded Mode
