| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display formula with values referenced
I want to display a formula where values are referenced from other cells.
For example: Column D displays the result of A-B. I want C to automatically display the actual formula with the referenced values, not the cell numbers. A B C D 1 10 7 10 - 7 = =A1-B1 "3" 2 20 12 20 - 12 = =A2-B2 "8" Is there a way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to display values instead of formula; Ctrl + ` doesn't work | Excel Discussion (Misc queries) | |||
| Referenced Cell Values | Excel Worksheet Functions | |||
| display formula instead of its values in some cells | Excel Worksheet Functions | |||
| Values won't display after altering a formula. | Excel Worksheet Functions | |||
| Is there a way to toggle cells between display of referenced data. | Excel Discussion (Misc queries) | |||
Threaded Mode
