Why Does Excel Return TRUE for TRUE Greater Than 1? (Comparison Rules Explained)
Question details
The user wants to understand why the formula =TRUE>1 evaluates to TRUE and how to properly compare Boolean values with numeric values in Excel.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Writing formulas that compare logical Boolean values (TRUE/FALSE) with numeric values.
- Observed behavior
- Excel evaluates =TRUE>1 as TRUE because logical values are ranked higher than numeric values in its internal comparison hierarchy.
Ensure you understand that Excel treats different data types with a specific hierarchy during direct comparisons unless they are explicitly converted.
Convert the Boolean Value to a Number Before Comparison
Force Excel to treat the Boolean TRUE as the number 1 to perform a standard numeric comparison.
By default, Excel considers text and Boolean values (TRUE/FALSE) to be mathematically greater than any number. To compare them correctly, you must explicitly coerce the Boolean value into a number (where TRUE becomes 1 and FALSE becomes 0).
Type =N(TRUE)>1 in your cell. The N() function converts TRUE to 1, evaluating as 1>1, which correctly returns FALSE.
Alternatively, you can use a double minus sign by typing =--TRUE>1. The double unary coerces the Boolean into a number before the comparison happens.
You can also trigger a mathematical operation by typing =1*TRUE>1. This forces Excel to convert TRUE into 1, resulting in FALSE.

Handle Complex Formulas Accurately with WPS Spreadsheet
WPS Spreadsheet provides a robust and highly compatible environment for handling complex logical and numeric comparisons. Evaluate formulas seamlessly using the exact same logic and functions you are used to.
- 1. Open your spreadsheet: Launch WPS Spreadsheet and select the cell where you want to perform the logical comparison.
- 2. Enter the formula: Type =N(TRUE)>1 or =--TRUE>1 to explicitly convert the Boolean value to a number.
- 3. Evaluate the result: Press Enter. WPS Spreadsheet will accurately calculate the result and return FALSE, matching standard spreadsheet logic.

Frequently Asked Questions
Why does Excel consider TRUE greater than a number?
Excel follows a strict internal hierarchy for data types. Logical values (TRUE and FALSE) are always evaluated as greater than text, and text is evaluated as greater than any number. Thus, TRUE is considered greater than 1, 100, or even 1,000,000 in a direct uncoerced comparison.
What is the numeric value of TRUE in Excel formulas?
When explicitly converted into a number using mathematical operations (like adding zero or multiplying by one), TRUE evaluates to 1 and FALSE evaluates to 0.
What does the double minus sign (--) do in Excel?
The double minus sign, known as a double unary operator, coerces non-numeric values like Booleans or text-formatted numbers into actual numeric values. For example, --TRUE becomes the number 1, allowing standard mathematical comparisons to take place.
Does this Boolean comparison rule apply to other spreadsheet software?
Yes, this is a standard spreadsheet convention. Programs like WPS Spreadsheet and Google Sheets follow the exact same data type hierarchy to maintain strict compatibility with Excel formulas.




