Posted 22 February 2024, 12:19 am EST
AND Function:
1) In any Excel worksheet, in cells A2 and A4, type the boolean value TRUE 2) In cell A1, enter formula =AND(A2:A4) The result in spreadjs is FALSE, but in Excel it is TRUE
ISREF Function:
=ISREF(INDIRECT(“‘SheetNameThatDoesNotExist’!A1”)) should produce FALSE, but returns TRUE