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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 3, 2011 at 05:29 AM
Related:
- Excel: If A1 = a 4 the comy content of b1,2,3
- Excel date format dd.mm.yyyy - Guide
- Screenshot in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Number to words in excel without vba - Guide
- Transfer data from one excel worksheet to another automatically - Guide
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
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
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
Apr 3, 2011 at 01:52 AM
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
Apr 3, 2011 at 05:29 AM