Excel: If A1 = a 4 the comy content of b1,2,3 [Solved/Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Please help!

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

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
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