| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display formula with values referenced
I think this can only be done using VBA...
"kdags" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display formula with values referenced
if your equation stays constant, you can use this
=D10 &" - "&D10&" =" this will show up as 33 - 33 = You can add more using & sign "kdags" wrote: 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display formula with values referenced
Thank you. That's exactly what I was looking for.
"Raz" wrote: if your equation stays constant, you can use this =D10 &" - "&D10&" =" this will show up as 33 - 33 = You can add more using & sign "kdags" wrote: 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? |
| Reply |
| 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) | |||
Linear Mode
