Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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

See more

1 reply

Answer 1 / 1
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
Report

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
Report
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
Ask a question