|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 8th, 2006, 01:23 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
populating a cell with parameters
I need to populate cells with another cell
ex. if a2 thru a6 = 872 I need b2 thru b6 = text message Any suggestions on how to do it??? 
|
|
#2
October 8th, 2006, 02:26 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
populating a cell with parameters
Enter this in B2 and copy down to B6
=IF(SUM($A$2:$A$6)=872,"is 872","not 872") OR if you mean each of A2 thru A6 = 872 then In B2 enter =IF(A2=872,"is 872","not 872") Gord Dibben MS Excel MVP On Sat, 7 Oct 2006 17:23:02 -0700, Shannon Bisram Shannon wrote: I need to populate cells with another cell ex. if a2 thru a6 = 872 I need b2 thru b6 = text message Any suggestions on how to do it???
|
|
#3
October 8th, 2006, 03:27 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
populating a cell with parameters
Gord,
If the poster means A2 = 872 and A3 = 872 ...... and A6 = 872, will the following formula work? array formula i.e. CTRL+SHIFT+ENTER Enter into B2 and copy down. =IF(AND($A$2:$A$6=872),"yes","no") Is there a 4th way to interpret the post? Epinn "Gord Dibben" gorddibbATshawDOTca wrote in message ... Enter this in B2 and copy down to B6 =IF(SUM($A$2:$A$6)=872,"is 872","not 872") OR if you mean each of A2 thru A6 = 872 then In B2 enter =IF(A2=872,"is 872","not 872") Gord Dibben MS Excel MVP On Sat, 7 Oct 2006 17:23:02 -0700, Shannon Bisram Shannon wrote: I need to populate cells with another cell ex. if a2 thru a6 = 872 I need b2 thru b6 = text message Any suggestions on how to do it???
|
|
#4
October 8th, 2006, 12:21 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
populating a cell with parameters
Hi
If that is what is required, then there is no need for an array formula. =IF(COUNTIF($A$2:$A$6,872)=6,"Yes,"No") -- Regards Roger Govier "Epinn" wrote in message ... Gord, If the poster means A2 = 872 and A3 = 872 ...... and A6 = 872, will the following formula work? array formula i.e. CTRL+SHIFT+ENTER Enter into B2 and copy down. =IF(AND($A$2:$A$6=872),"yes","no") Is there a 4th way to interpret the post? Epinn "Gord Dibben" gorddibbATshawDOTca wrote in message ... Enter this in B2 and copy down to B6 =IF(SUM($A$2:$A$6)=872,"is 872","not 872") OR if you mean each of A2 thru A6 = 872 then In B2 enter =IF(A2=872,"is 872","not 872") Gord Dibben MS Excel MVP On Sat, 7 Oct 2006 17:23:02 -0700, Shannon Bisram Shannon wrote: I need to populate cells with another cell ex. if a2 thru a6 = 872 I need b2 thru b6 = text message Any suggestions on how to do it???
|
|
#5
October 8th, 2006, 08:00 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
populating a cell with parameters
Thanks, Roger. I love it. Probably easy on the system without the array formula. If I keep learning from my teachers, hopefully one day I become smarter. Practice makes perfect.
Epinn "Roger Govier" wrote in message ... Hi If that is what is required, then there is no need for an array formula. =IF(COUNTIF($A$2:$A$6,872)=6,"Yes,"No") -- Regards Roger Govier "Epinn" wrote in message ... Gord, If the poster means A2 = 872 and A3 = 872 ...... and A6 = 872, will the following formula work? array formula i.e. CTRL+SHIFT+ENTER Enter into B2 and copy down. =IF(AND($A$2:$A$6=872),"yes","no") Is there a 4th way to interpret the post? Epinn "Gord Dibben" gorddibbATshawDOTca wrote in message ... Enter this in B2 and copy down to B6 =IF(SUM($A$2:$A$6)=872,"is 872","not 872") OR if you mean each of A2 thru A6 = 872 then In B2 enter =IF(A2=872,"is 872","not 872") Gord Dibben MS Excel MVP On Sat, 7 Oct 2006 17:23:02 -0700, Shannon Bisram Shannon wrote: I need to populate cells with another cell ex. if a2 thru a6 = 872 I need b2 thru b6 = text message Any suggestions on how to do it???
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
