elgringo56
Well-known Member
- Joined
- Apr 15, 2002
- Messages
- 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?