View Single Post
  #1   Report Post  
SeeFar
 
Posts: n/a
Default 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.