Complex if statement

[thedeadzeds]

Hi Guys,

Is the following at all possible in an If statement?

If columns H to Q contains

Comparative-Comparative (Remediation - Original/New Outcome, Comparative-LH3 Review Required)

or

Pro-Rata-Comparative (Remediation - Original/New Outcome, Pro-Rata-LH3 Review Required)

Show “Refi” else show “Uphold”

Many thanks

 

[jasonb75]

Your question is more than a little vague.

Should one of those 2 phrases appear in 1 or more columns, every column, or parts of it in each column to make up the phrase?

 

[thedeadzeds]

Your question is more than a little vague.

Should one of those 2 phrases appear in 1 or more columns, every column, or parts of it in each column to make up the phrase?

Apologies, It should be if any of those 2 phrases appear in 1 or more columns then show the if statement in column M

Many thanks

 

[jasonb75]

Something like

=IF(SUM(COUNTIF(H:Q,{"Phrase 1","phrase 2"})),"Refi","Uphold")

I've used Phrase 1 & 2 instead of your actual phrases to make the formula easier to read on the forum.

 

[thedeadzeds]

perfect, thanks very much