change values in a column
 

i am looking for a way to be able to drag the information in a cell down a
column keeping some information constant while changing others. For example:
=IF($B$2=4,"4",IF($C$2=4,"4"))
=IF($B$2=5,"5",IF($C$2=5,"5"))
I would like to be able to have the following cells continue with the number
sequence
=IF($B$2=6,"6",IF($C$2=6,"6"))
=IF($B$2=7,"7",IF($C$2=7,"7")) etc.
thx

--
thanx

change values in a column
 

Try it like this:

=IF($B$2=ROW(A4),""&ROW(A4),IF($C$2=ROW(A4),""&ROW (A4)))

and copy it down. You do not specify what to do if neither B2 nor C2 =
4 (in your first formula).

Hope this helps.

Pete

On Apr 21, 10:25*pm, dmack wrote:
i am looking for a way to be able to drag the information in a cell down a
column keeping some information constant while changing others. *For example:
=IF($B$2=4,"4",IF($C$2=4,"4"))
=IF($B$2=5,"5",IF($C$2=5,"5"))
I would like to be able to have the following cells continue with the number
sequence
=IF($B$2=6,"6",IF($C$2=6,"6"))
=IF($B$2=7,"7",IF($C$2=7,"7")) etc.
thx

--
thanx

change values in a column
 

=IF($B$4=ROW(A6),6,400)
or
=IF(OR($B$4=ROW(a6),$C$4=ROW(a6)),6,900)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"dmack" wrote in message
...

i am looking for a way to be able to drag the information in a cell down a
column keeping some information constant while changing others. For
example:
=IF($B$2=4,"4",IF($C$2=4,"4"))
=IF($B$2=5,"5",IF($C$2=5,"5"))
I would like to be able to have the following cells continue with the
number
sequence
=IF($B$2=6,"6",IF($C$2=6,"6"))
=IF($B$2=7,"7",IF($C$2=7,"7")) etc.
thx

--
thanx

change values in a column
 

Try this in the starting cell, say in D2:
=IF($B$2=ROWS($1:1)+2,ROWS($1:1)+2,IF($C$2=ROWS($1 :1)+2,ROWS($1:1)+2,""))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dmack" wrote:

i am looking for a way to be able to drag the information in a cell down a
column keeping some information constant while changing others. For example:
=IF($B$2=4,"4",IF($C$2=4,"4"))
=IF($B$2=5,"5",IF($C$2=5,"5"))
I would like to be able to have the following cells continue with the number
sequence
=IF($B$2=6,"6",IF($C$2=6,"6"))
=IF($B$2=7,"7",IF($C$2=7,"7")) etc.
thx

--
thanx