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
|