Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
=(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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I wish to automatically populate cells with list data when a item. | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
populate cells with data from another sheet | Excel Worksheet Functions | |||
How do I select cells and make the info populate into a form? | Excel Worksheet Functions | |||
How to populate formula in range of vertical cells to next colum | Excel Worksheet Functions |