TRUE

TRUE()

Returns the logical value True.

REMARKS
* This function is only available for backwards compatibility and should not be used.
* This function should be replaced with the keyword True.
* This is one of the few functions that does not require any arguments.
* You can also type the word TRUE directly into a cell.
* You can use the IF function to return the value based on whether a condition is True or False.
* You can use the IFS function to return the value based on multiple True or False conditions.
* This is similar to the FALSE function.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 AB
1=TRUE() = True5
2TRUE 
3=(TRUE()=TRUE) = True 
4=IF(B1<10, TRUE()) = True 
5=IF(B1<10, TRUE) = True 

1 - What does this function return.
2 - The same value can be typed into a cell.
3 - These two values are equivalent.
4 - Is the value in cell "B1" less than 10.
5 - Is the value in cell "B1" less than 10.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top