Created attachment 125447 [details] Example bugs The evaluation, for example: A1: 700 A2: 600 A3: 500 A4: 600 A5: 10000 A6: 2000 B2: =IF(AND(A1>=A2;A3<=A4);"";A6) Result B2 is TRUE??? Spanish Evaluando, por ejemplo: A1: 700 A2: 600 A3: 500 A4: 600 A5: 10000 A6: 2000 B2: =SI(Y(A1>=A2;A3<=A4);"";A6) Resultado de B2 es VERDADERO??? Comentario: Esto parece ocurrir sólo cuando la opcion verdad esta como respuesta vacía ("")
Yes, because AND(A1>=A2;A3<=A4) is FALSE hence the result of A6 is returned and apparently B2 is formatted as BOOLEAN => anything != 0 is displayed as TRUE.
Isn't AND(A1>=A2;A3<=A4) == TRUE?
(Sorry, changed it to WORKSFORME because despite the correction, it worked for me.)
The test file does not match the description. Column C1 contains =IF(AND(B1>=E1,B1<=E1),"",B1) which is the equivalent of IF(E1=E1) because it is otherwise a contradiction. So, this will always return TRUE, and thus, C1 gets the value of B1, which contains a number. Also, the file has C2 formatted as boolean. Boolean formatting shows FALSE on 0 and TRUE otherwise.