Forum Discussion

Copper Contributor

Jun 01, 2020

Solved

IF formula on various texts

I am looking at a formula to show IF any of 4 cells shows "YES" then the auto input should show YES, otherwise it should show NO. How do i do this please.

Formulas and Functions

mtarler
Jun 01, 2020
Ian_Grant simply:
=IF(OR(cell1="Yes", cell2="Yes"....), "Yes", "No")
but you could make it more robust doing things like:
=IF(OR(UPPER(LEFT(cell1,1))="Y", UPPER(LEFT(cell2,1))="Y",....), "Yes", "No")
so that "yes", "Yes", "YES", "Y", or "y" are all counted as "Yes" (but so will any other entry starting with "y")

mtarler

Silver Contributor

Jun 01, 2020

Ian_Grant simply:

=IF(OR(cell1="Yes", cell2="Yes"....), "Yes", "No")

but you could make it more robust doing things like:

=IF(OR(UPPER(LEFT(cell1,1))="Y", UPPER(LEFT(cell2,1))="Y",....), "Yes", "No")

so that "yes", "Yes", "YES", "Y", or "y" are all counted as "Yes" (but so will any other entry starting with "y")