Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formula for charts
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formula for charts
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formula for charts
Thanks, Andy! Got it working.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |