View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Cell Formula substitution.

Might this help you?

<Tools <Formula Auditing
And, at the bottom, click on "Formula Auditing Toolbar".

This gives you a floating toolbar which, when one of your formula cells is
selected, you click on an option, and it will insert arrows to precedent and
dependant cells that are contained in the formula of the selected cell.

Play around with all the choices and see if it helps.

You can anchor the toolbar if you wish.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"id3372" wrote in
message ...

This is a multi-step problem. I want to try and simplify it to
understand it better. The answer should be 1 but it never is so I
thought that if I could reduce it down to a single line problem, I
could simplify it and understand it better.


--
id3372
------------------------------------------------------------------------
id3372's Profile:
http://www.excelforum.com/member.php...o&userid=36176
View this thread: http://www.excelforum.com/showthread...hreadid=559552