answersLogoWhite

0

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

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

When working with predefined formulas in excel what category contains the boolean functions?

They are under the category of Logical Functions.


MAX MIN COUNT and SUM are examples of what?

They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.


What function in Excel deals with true or false?

The different functions from the Logical functions category deal with true and false. The main one of them is the IF function.


In Excel you can create a worksheet that will be able to make decisions based on the information that appears in other cells. In what category of the Insert Function dialog box will you find functions?

The Logical category functions are the ones most appropriate, like the IF function, but some functions in other categories could be used too, like SUMIF in the Math & Trig category.


How many functions are in Microsoft Excel 2007?

348, at my count


Can a person complete calculations in Microsoft Excel 2003?

Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.


Do statistical functions ignore blank cells in Microsoft Excel?

Yes it does.


Why is there a need to know what functions are in creating formulas in Microsoft Excel?

Functions are basically built-in formulas in Excel. They are used extensively in Excel, so it is very important to know how to use them.


What are the types of formula in Microsoft Excel?

You could not really classify formulas into types as the amount of formulas are infinite and you can have a variety of things happening in a formula. Functions come in categories, and that is maybe what you mean. It will depend on which version of Excel you have, but these are the categories available in later versions: Cube functions Database functions Date and time functions Engineering functions Financial functions Information functions Logical functions Lookup and reference functions Math and trigonometry functions Statistical functions Text functions


What is the name of the pre-written formulas in Excel that helps to complete statistics?

They are called functions. Excel has a specific category or functions used to calculate statistics.


What are the functions Microsoft Excel?

Functions allow you to perform some mathematical or string procedures to other cells.


What is dry-excel?

That term does not have anything to do with Microsoft Excel. Please ask a more specific question and ensure you put it in the correct category.