Multiple Statements

[petermccallion]

Why will my formula not return a blank cell if the statements not met.

=IF(AND(I17="ü",K17="ü",M17="ü",S17="ü",U17="ü"),IF(OR(O17="ü",Q17="ü"),IF(OR(W17="ü",Y17="ü",AA17="ü"),"ü","")))
the "ü" is a windings font for a tick symbol which if the conditions are works ok but if the conditions are not met returns FALSE but i would prefer the cell to be blank, which I believe ,"ü","") at the end of the if statement should return. i have tried &"" after the formula but this has no effect.

any ideas would be greatly appreciated.

thanks peter

 

[petermccallion]

Sorry row number changed as first few columns contained sensitive data and i copied from one spreadsheet to another .

=IF(AND(I4="ü",K4="ü",M4="ü",S4="ü",U4="ü",OR(O4="ü",Q4="ü"),OR(W4="ü",Y4="ü",AA4="ü")),"ü","")
this formula worked but I don't understand why the first or function needs to be in the and function

Thanks for your help in finding this solution

 

[6StringJazzer]

This formula exactly maps to the text description of the logic you want. If you read your description you will see that your description of "or" also falls within the "and".

 

[petermccallion]

ok thanks