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
- Posts
-
4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
769Apr 3, 2011 at 05:29 AM