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

Solved/Closed
Stormdronk - Apr 2, 2011 at 04:39 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Apr 3, 2011 at 05:29 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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
0
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
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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
0