populate a limited # of cells with a set value
 

I need to populate a limited # of cells in a column with a set value.

Cell A1 contains the # of cells that should be populated down column
starting at A3.
Cell A2 contains the values that is to be populated.
Once the # of cells is populated, the cells below that shopuld be populated
with 0

any suggestions?
thank you in advance ! jane

Try this:

=(ROW()<=$A$1+2)*$A$2

And copy down as needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Jane" wrote in message
...
I need to populate a limited # of cells in a column with a set value.

Cell A1 contains the # of cells that should be populated down column
starting at A3.
Cell A2 contains the values that is to be populated.
Once the # of cells is populated, the cells below that shopuld be populated
with 0

any suggestions?
thank you in advance ! jane

If the data is Text, try this:

=IF(ROW()<=$A$1+2,$A$2,0)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Jane" wrote in message
...
I need to populate a limited # of cells in a column with a set value.

Cell A1 contains the # of cells that should be populated down column
starting at A3.
Cell A2 contains the values that is to be populated.
Once the # of cells is populated, the cells below that shopuld be populated
with 0

any suggestions?
thank you in advance ! jane

thank you! - I will try this..... if I could impose another question
connected to this....
I have other criteria to consider in addition to what is stated below. Here
are my conditions as stated in another formula:
if this is true, =AND($J$3=1,$I21=1,K$3="x"), then I would want to apply the
formula below.

am I being clear? do you need more info to answer?

"Jane" wrote:

I need to populate a limited # of cells in a column with a set value.

Cell A1 contains the # of cells that should be populated down column
starting at A3.
Cell A2 contains the values that is to be populated.
Once the # of cells is populated, the cells below that shopuld be populated
with 0

any suggestions?
thank you in advance ! jane

=(AND($J$3=1,$I21=1,K$3="x",ROW()<=$A$1+2))*$A$2

note: I21 will become i21,i22,i23...

"Jane" wrote:

thank you! - I will try this..... if I could impose another question
connected to this....
I have other criteria to consider in addition to what is stated below. Here
are my conditions as stated in another formula:
if this is true, =AND($J$3=1,$I21=1,K$3="x"), then I would want to apply the
formula below.

am I being clear? do you need more info to answer?

"Jane" wrote:

I need to populate a limited # of cells in a column with a set value.

Cell A1 contains the # of cells that should be populated down column
starting at A3.
Cell A2 contains the values that is to be populated.
Once the # of cells is populated, the cells below that shopuld be populated
with 0

any suggestions?
thank you in advance ! jane

and to add the other 9 sets of criteria, I should add to the end of the
formula below: +(AND(($J$3=2,$I21=2,K$3="x",ROW()<=$A$1+2))*$A$2) +(AND.......?

"LanceB" wrote:

=(AND($J$3=1,$I21=1,K$3="x",ROW()<=$A$1+2))*$A$2

note: I21 will become i21,i22,i23...

"Jane" wrote:

thank you! - I will try this..... if I could impose another question
connected to this....
I have other criteria to consider in addition to what is stated below. Here
are my conditions as stated in another formula:
if this is true, =AND($J$3=1,$I21=1,K$3="x"), then I would want to apply the
formula below.

am I being clear? do you need more info to answer?

"Jane" wrote:

I need to populate a limited # of cells in a column with a set value.

Cell A1 contains the # of cells that should be populated down column
starting at A3.
Cell A2 contains the values that is to be populated.
Once the # of cells is populated, the cells below that shopuld be populated
with 0

any suggestions?
thank you in advance ! jane