Explanation
Excel’s formula engine has some quirks that you should be aware of.
One of these quirks is that Excel will treat a text value as larger than a number by default.
For example:
The second formula above returns TRUE when you probably expect it to return FALSE.
you could see this behavior in the worksheet shown in cells D9:D11.
For example, theCOUNTIFandCOUNTIFSfunctions don’t exhibit this behavior.
For example, theSUMPRODUCTformula in cell F7 returns 4:
This is an example of usingBoolean logicin a formula.
