Why Excel Evaluates FALSE Greater Than Zero as TRUE
Question details
The user needs to understand why the logical expression FALSE > 0 evaluates to TRUE in Excel, despite FALSE commonly being associated with the numeric value 0 in Boolean algebra.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Comparing a Boolean value (FALSE) directly with a numeric value (0) using a greater-than operator in a spreadsheet formula.
- Observed behavior
- Excel returns TRUE for the expression FALSE > 0 instead of returning FALSE, because its sorting and comparison rules rank Boolean data types strictly higher than numeric data types.
Before modifying your formulas, identify whether your logical tests are meant to compare raw data types or if they require mathematical evaluation of those values.
Explicitly Convert Boolean Values to Numbers
Force Excel to coerce TRUE and FALSE into 1 and 0 before applying comparison operators to achieve standard mathematical results.
In Excel, comparison operators like greater-than (>) and less-than (<) compare values based on their data type hierarchy rather than their numerical equivalence. Because the Boolean data type ranks higher than numbers, any Boolean (TRUE or FALSE) is evaluated as greater than any number (including 0 and positive integers).
To fix this, you must apply a mathematical operation to the Boolean value to trigger Excel's arithmetic coercion, converting TRUE to 1 and FALSE to 0.
Select the cell containing the logical comparison that is returning the unexpected TRUE result (for example, =A1>0 where A1 contains FALSE).
Insert a double negative (--) directly before the Boolean cell reference to force arithmetic coercion. Your formula should look like =--A1>0.
You can also enclose the Boolean reference in parentheses and multiply it by 1, resulting in a formula like =(A1*1)>0.
Press the Enter key. Excel will now evaluate the Boolean as 0 before making the comparison, correctly returning FALSE for 0 > 0.

Use the N() Function for Numeric Conversion
Wrap your Boolean cell references in the N() function to explicitly translate TRUE to 1 and FALSE to 0 before comparing them to other numbers.
Handle Complex Logical Formulas with WPS Spreadsheets
WPS Spreadsheets provides advanced formula calculation that perfectly mirrors standard spreadsheet logic. You can seamlessly convert Boolean values, apply the N() function, and write complex logical comparisons exactly as you would in Microsoft Excel.
- 1. Open your spreadsheet: Launch WPS Spreadsheets and open the document containing your logical comparisons.
- 2. Select the target cell: Click on the cell where you want to perform a numeric evaluation of a Boolean value.
- 3. Apply mathematical coercion: Type your formula using a double unary operator or the N() function, such as =--FALSE>0 or =N(FALSE)>0.
- 4. Calculate the result: Press Enter. WPS Spreadsheets will accurately coerce the Boolean value and deliver the mathematically correct result.

Frequently Asked Questions
Why does Excel evaluate FALSE as greater than zero?
In mixed-type comparisons, Excel follows a strict data type hierarchy. Under these sorting rules, the Boolean data type (TRUE and FALSE) is ranked higher than the numeric data type. Therefore, Excel considers any Boolean value strictly greater than any numeric value, including zero.
Does TRUE equal 1 and FALSE equal 0 in Excel?
In arithmetic operations (like multiplication, addition, or subtraction), Excel automatically coerces TRUE to 1 and FALSE to 0. However, logical comparison operators (<, >, =) do not trigger this automatic arithmetic conversion, which is why manual coercion is sometimes necessary.
How do I force Excel to treat FALSE as 0 in an IF statement?
You can force the conversion by performing a mathematical operation on the Boolean value. For example, multiply the Boolean reference by 1 (A1 * 1), add zero (A1 + 0), or use a double negative (--A1) inside the logical test of your IF statement.
Why does VBA give a different result for FALSE > 0 than worksheet formulas?
Unlike Excel worksheet formulas which rely on data type sorting rules, Visual Basic for Applications (VBA) automatically converts Boolean values to numeric values when executing comparison operators. As a result, VBA correctly evaluates False > 0 as False.




