software

Hi all,

I have the following function define in one cell: =D49-D49*(B8^2)

D49 is dynamic. However, B8 is a constant cell referring to a constant
value.

When I tried to copy the function to another cell, B8 is changed to B9.
I only want D49 to change.

How do I keep Excel from changing B8?

Thanks!Hi,

You need to use absolute references ($) rather then relative ones.
=D49-D49*($B$8*$B$8)

Cheers
Andy

PPP wrote:
gt; Hi all,
gt;
gt; I have the following function define in one cell: =D49-D49*(B8^2)
gt;
gt; D49 is dynamic. However, B8 is a constant cell referring to a constant
gt; value.
gt;
gt; When I tried to copy the function to another cell, B8 is changed to B9.
gt; I only want D49 to change.
gt;
gt; How do I keep Excel from changing B8?
gt;
gt; Thanks!
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Thanks, Andy! Got it working.