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
Hello,
In my spreadsheet, currently C1 copies the number in A1. (=A1)
I need this command to be overridden if B1 contains the text VISUAL
Thank you kindly for your assistance.
In my spreadsheet, currently C1 copies the number in A1. (=A1)
I need this command to be overridden if B1 contains the text VISUAL
Thank you kindly for your assistance.
Related:
- Copy cell, unless another call says specific text
- How to find specific words on a page - Guide
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Based on the cell values in cells b77 ✓ - 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"