Formula Errors

Why Does Excel Return TRUE for TRUE Greater Than 1? (Comparison Rules Explained)

Camila MilosovichCamila Milosovich Nov 10, 2026 871 views

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.

Why Does Excel Return TRUE for TRUE Greater Than 1?
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.
Before you start

Ensure you understand that Excel treats different data types with a specific hierarchy during direct comparisons unless they are explicitly converted.

Solution 1Recommended

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).

1
Use the N() function

Type =N(TRUE)>1 in your cell. The N() function converts TRUE to 1, evaluating as 1>1, which correctly returns FALSE.

2
Use the double unary operator

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.

3
Multiply by 1

You can also trigger a mathematical operation by typing =1*TRUE>1. This forces Excel to convert TRUE into 1, resulting in FALSE.

Convert the Boolean Value to a Number Before Comparison
Excel's Comparison Hierarchy: In Excel's sorting and comparison hierarchy, Logical values (TRUE/FALSE) are placed above Text, which are both placed above Numbers. This is why TRUE is considered greater than any number.
Resolve Formula Errors with WPS Office

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. 1. Open your spreadsheet: Launch WPS Spreadsheet and select the cell where you want to perform the logical comparison.
  2. 2. Enter the formula: Type =N(TRUE)>1 or =--TRUE>1 to explicitly convert the Boolean value to a number.
  3. 3. Evaluate the result: Press Enter. WPS Spreadsheet will accurately calculate the result and return FALSE, matching standard spreadsheet logic.
100% compatible with Microsoft Excel formulas, functions, and comparison rules.Built-in formula error checking and step-by-step evaluation tools.Free and lightweight spreadsheet alternative with a familiar interface.Cross-platform support for Windows, Mac, Linux, iOS, and Android.
microsoft office alternative - wps office

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.