# Excel: If A1 = a 4 the comy content of b1,2,3

Solved/Closed
Stormdronk - Apr 2, 2011 at 04:39 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 3, 2011 at 05:29 AM
Hello,

If A1 = a 4 the comy content of b1,2,3,4,5 to c1,2,3,4,5

The 4 in a1 are generated by a formula.

Thanks

Related:

## 1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 2, 2011 at 06:31 PM
what if they are not same ? whats in c before
since all is not know, you can use formula like this in c1

=if(\$a\$1=4, b1, "") so if a1=4, it show the value of b1 in c1 else show "" in c1
Hi, Thanks this worked.

Just a nother question. Is it posible to say: If a1=4 then show value of b1 in the next open cell of c.

In other words if c1 and c2 have content in then show bi in c3

Thanks
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 3, 2011 at 05:29 AM
I think for that you may have to resort to macro. Since you cannot use C to make determination if c is empty or not ( it is never empty as there is a formula always), so a macro can put the value in c in some way