On Thu, 14 Dec 2006 17:56:34 -0000, "Roger Govier"
wrote:

Hi
I don't understand. Why would I not just use E7 in any further
calculations?

In your particular scenario, I agree.
I was giving the generalised case of why it may be of advantage. The
cell could be carrying a formula with some sort of lookup, and the
resulting value could then be used as part of further calculation,
without recourse to repeating the lookup.

Ok. If I needed E7*E9 + G7*G9 or some such rather than just E7. Right?
Good point, thanks.

--
Running Excel 2000 SP-3 on Windows 2000