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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
Oct 6, 2015 at 03:05 PM
=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
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
Oct 7, 2015 at 11:56 AM
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