The Excel TRUE function returns the Boolean value TRUE. The function provides compatibility with other spreadsheet programs.
In most cases, using the TRUE function is unnecessary if you work in Excel. The function’s only purpose is to generate the logical value TRUE.
The syntax is simple, and the TRUE() function does not use an argument.
=TRUE()
TRUE Function Example
Take a closer look at the formulas below! Both formulas use the IF function, and the results are the same.

- =IF(B3>=30, TRUE())
- =IF(B3>=30, TRUE)
The result is FALSE because the value is less than 30. Don’t forget that logical expression will automatically generate only two types of output: the formula will return TRUE or FALSE results based on Boolean logic.
Workaround with SWITCH and TRUE functions
In the following example, we’ll introduce a trick! With its help, you can use logical operators with the SWITCH function.
Our goal is simple: reduce the actual price by 10% if the price is greater than or equal to 150 and less than equal to 300. If both logical tests are TRUE, the formula will return the text string: “10%”. We will use the “-” string to handle errors in other cases.
=SWITCH(TRUE, AND(C4>=150,C4<=300),”10%”,”-”)

Evaluate the formula!
- SWITCH(TRUE, …): The SWITCH function evaluates a given expression and matches it to specified cases. Here, TRUE is the expression being evaluated, meaning SWITCH will check if any subsequent conditions are TRUE and return the corresponding result.
- AND(C4 >= 150, C4 <= 300): This part uses the AND function to test if two conditions are met. If both conditions are TRUE (meaning the price is between 150 and 300, inclusive), AND returns TRUE; otherwise, it returns FALSE.
- C4 >= 150: Checks if the value in C4 is greater than or equal to 150.
- C4 <= 300: Checks if the value in C4 is less than or equal to 300.
- Matching TRUE in SWITCH: Since SWITCH was set to evaluate TRUE, it will return the value associated with the first TRUE match it finds. If AND(C4 >= 150, C4 <= 300) evaluates to TRUE, SWITCH will return “10%”.
- Error handling: If the AND condition is FALSE, meaning C4 is not between 150 and 300, the SWITCH function will return “-” as a fallback.
This formula setup handles conditional text output based on specific criteria without using multiple IF statements.