| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Displaying numbers used in formula
Hello. I have a spreadsheet with many elementary formulas. The VP wants the
numbers used in the formulas displayed next to the cell with the formula. As an example...Let's say in J11-J14 I have the numbers 34, 67, 57 and 48. In D10 I have the formula: =(J11/J12)+(J13/J14). Great, but now in E10 the VP wants to see: (34/67)+(57/48). Of course I could do it manually, but there are LOTS of formulas on each sheet and the numbers change weekly. Is there a way to EASILY automate this? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| How to add 4 of 5 highest numbers using a formula | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
| Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
| How can I stop Excel from displaying rounded numbers? Credit car. | Excel Discussion (Misc queries) | |||
Threaded Mode
