populate a limited # of cells with a set value

[Jane]

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

 

[RagDyeR]

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!
==============================================


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

 

[RagDyeR]

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!
==============================================


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

 

[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?

 

[LanceB]

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

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

 

[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.......?