Jun 01 2020 04:28 AM
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.
Jun 01 2020 05:49 AM
Solution@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")
Jun 05 2020 06:04 AM
Jun 01 2020 05:49 AM
Solution@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")