Copy cell, unless another call says specific text
Closed
Damo
-
Oct 6, 2015 at 02:11 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 7, 2015 at 11:56 AM
rizvisa1 Posts 4478 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
- How to find specific words on a page - Guide
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
- If cell contains multiple specific text ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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"