Copy cell, unless another call says specific text
Closed
Damo
-
Oct 6, 2015 at 02:11 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 7, 2015 at 11:56 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 7, 2015 at 11:56 AM
Related:
- Copy cell, unless another call says specific text
- Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- If cell contains specific text then return value in another cell vba - Excel Forum
- Count if cell contains number - Excel Forum
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Oct 6, 2015 at 03:05 PM
Oct 6, 2015 at 03:05 PM
=if(b1<>"", a1, "now what")
Oct 7, 2015 at 10:42 AM
Is that exactly what I should paste into C1?
because VISUAL is the exact word that I am wanting cell C1 to look for in B1
Oct 7, 2015 at 11:56 AM
What I gave you was an idea that you can use an if statement.
what that statement is saying is that
if A1 is not equal to "", then show whats in A1
and if a1 = "", then show "now what"