Excel for Mac 16.112.2, September 30, 2026. Archived worksheet formulas and their saved Excel results read November 12, 2026. Boolean caches use 1 for TRUE and 0 for FALSE. F5 is a number.
CSV SHA-256: 88c4e05bf4672e67a8d20e82e2be7c1986a3b6cf1992b1551378ac8e1a4655ee

first-import
F2  =AND(ISTEXT(A2),EXACT(A2,"00127"),EXACT(A3,"00008"))  =>  1
F3  =AND(ISTEXT(A4),EXACT(A4,"123456789012345678"))  =>  1
F4  =AND(EXACT(B2,"José"),EXACT(B3,"李明"),EXACT(B4,"Zoë"))  =>  0
F5  =SUM(C2:C4)  =>  18
F6  =AND(C2=12.5,C3=7.5,C4=-2,COUNT(C2:C4)=3)  =>  1

pass
F2  =AND(ISTEXT(A2),EXACT(A2,"00127"),EXACT(A3,"00008"))  =>  1
F3  =AND(ISTEXT(A4),EXACT(A4,"123456789012345678"))  =>  1
F4  =AND(EXACT(B2,"José"),EXACT(B3,"李明"),EXACT(B4,"Zoë"))  =>  1
F5  =SUM(C2:C4)  =>  18
F6  =AND(C2=12.5,C3=7.5,C4=-2,COUNT(C2:C4)=3)  =>  1