Hi,
You need to use absolute references ($) rather then relative ones.
=D49-D49*($B$8*$B$8)
Cheers
Andy
PPP wrote:
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!
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info