0
Excel has a category called Logical Functions. The IF function is the one of those that most people use and associate with returning True or False values. Other functions also return True or False values. There is a TRUE function and a FALSE function. The OR function and the AND function can be used to return True or False values too. The NOT function can reverse a True or False value, so it also returns True or False.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
List the functions for the category 'Logical' in Microsoft Excel 2003?
A logical function is one that can return a true value or a false value. They are usually used in doing comparisons and seeing if things are equal to each other or not, or which is higher or lower. The logical functions that Excel provides are: TRUE FALSE AND OR NOT IF
What is the breakpoint in Excel?
In excel it is the lowest value for a specific category or series in a lookup table.
Can true and false be summed with excel?
Yes. TRUE has the value 1 and FALSE has the value of 0.
Which function returns one value when a condition is met and returns another value when it is not met in Excel?
The IF function. See the related question below.
Function returns the value true if at least one argument is true and false if all arguments are false in Microsoft Excel?
You need to use the OR function. You could have something like this:=OR(A2>5,A4>10,A6>20)
What is a named operation that returns a value in the Excel program used to simplify formulas?
A function.
What would be a formula for absolute value in excel?
Use the function ABS. =ABS(-11) returns the value 11.
What excel function searches for a specific value in a table and returns that value's relative position from the table not the value itself?
The MATCH function.
What function is a logical function that returns one value if the statement is true and returns a different value if the statement is false?
isdigit is an example (see in ctype.h)
What function searches for a specific value in a table and returns that value's relative position from the table not the value itself in Excel?
The MATCH function can do that.
How can we use the ABS function in Excel?
ABS returns the absolute value, so you use it any time you want to view or calculate with the absolute value.
What is an Excel reference function that looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify?
hlookup
