Draging cell contents

elgringo56 · Apr 23rd, 2002, 11:48 AM

In cell M1 I have the following formula: =IF(AA1<>"",(K1),"". Cell AA1 contains a possible value. Cell K1 contains a Constant. I want to drag this formula down thru 500 cells. When doing so, I want the AA1 value to increment (ie., AA2,AA3,AA4.... I want the K1 value to remain constant (the same in all 500 cells. Is this possible?

Mark W. · Apr 23rd, 2002, 11:51 AM

Yes... change K1 to $K$1. You may want to review the Excel Help Index topic for "Move or copy a formula".

[ This Message was edited by: Mark W. on 2002-04-23 11:58 ]

elgringo56 · Apr 23rd, 2002, 12:18 PM

Hey, thanks guy. I owe you

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 11:48 AM	#1
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	In cell M1 I have the following formula: =IF(AA1<>"",(K1),"". Cell AA1 contains a possible value. Cell K1 contains a Constant. I want to drag this formula down thru 500 cells. When doing so, I want the AA1 value to increment (ie., AA2,AA3,AA4.... I want the K1 value to remain constant (the same in all 500 cells. Is this possible?

Apr 23rd, 2002, 11:51 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Yes... change K1 to $K$1. You may want to review the Excel Help Index topic for "Move or copy a formula". [ This Message was edited by: Mark W. on 2002-04-23 11:58 ]

Apr 23rd, 2002, 12:18 PM	#3
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	Hey, thanks guy. I owe you