Excel: If A1 = a 4 the comy content of b1,2,3
Solved/Closed
Stormdronk
-
Apr 2, 2011 at 04:39 AM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Excel: If A1 = a 4 the comy content of b1,2,3
- Copy of shortcut to (1) (2) (3) (4) remover ✓ - Forum - Viruses/Security
- How to add custom content to sims 2 ✓ - Forum - The Sims
- Formula:IF E18 = 1, 2, 3, 4 or 5 Then End Result = G18, G19 etc. ✓ - Forum - Excel
- Write a program to print the following series on the screen 1 1 2 1 2 3 1 2 3 4 1 2 3 4 5 ✓ - Forum - Programming
- Shortcut virus on flash drive ✓ - Forum - Viruses/Security
1 reply
rizvisa1
Apr 2, 2011 at 06:31 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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