Hi
I'd like to write a formula which returns a value in a cell, depending on whether certain text is in two different cells in another tab.
The formula I've created is below:
It's meant to return the text in cell A3 from the "Scenarios" tab,
IF the words "As Is" are in cell A3 of the Scenarios tab AND
IF the word "Checked" in in cell C3 of the Scenarios tab.
Is there a way to do this? Thanks in advance.
=IF(and(ISNUMBER(SEARCH("As is",Scenarios!A3),ISNUMBER(SEARCH("Checked",Scenarios!c3),Scenarios!A3,""))))
Mr 2017.
I'd like to write a formula which returns a value in a cell, depending on whether certain text is in two different cells in another tab.
The formula I've created is below:
It's meant to return the text in cell A3 from the "Scenarios" tab,
IF the words "As Is" are in cell A3 of the Scenarios tab AND
IF the word "Checked" in in cell C3 of the Scenarios tab.
Is there a way to do this? Thanks in advance.
=IF(and(ISNUMBER(SEARCH("As is",Scenarios!A3),ISNUMBER(SEARCH("Checked",Scenarios!c3),Scenarios!A3,""))))
Mr 2017.