Forum Discussion
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.
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")
