Copy cell, unless another call says specific text

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
=if(b1<>"", a1, "now what")
0
=if(b1<>"", a1, "now what")

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
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Overridden would mean that =A1 would be should be replaced with some thing else. your question is not complete

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"
0