populating a cell with parameters

[Shannon Bisram]

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

 

[Gord Dibben]

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

 

[Epinn]

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

 

[Roger Govier]

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


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

 

[Epinn]

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

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


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