 |
|
 |
Microsoft Excel Logical Operators and Functions
 |
|
|
 Microsoft Excel / Functions and Formula A logical operator is one used to perform a comparison between two values and produce a result of true or false. Site: www.functionx.com
|
||
|
|
ReportRelated Tutorials
|
|
|
|
Microsoft Excel / Functions and Formula Microsoft Excel provides a series of functions destined to perform various types of financially related operations. These functions use common factors depending on the value that is being calculated. Many of these functions deal with investments or loan financing. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula Excel has most of the math and trig functions built into it. If you need to use the SIN, COS, TAN functions, they can be typed into any cell. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula The next function we will discuss is IF. The IF function will check the logical condition of a statement and return one value if true and a different value if false. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula Even when you have written various formulas and functions yourself, coming back to them at a later date often requires that you follow cell references to try to figure out what the formulas are doing. It would be great if you could simply add to the end of your formula some text that wouldn't interfere with the result, but would give you the information you require at a later stage. Site: www.brainbell.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula An expression is a combination of values and symbols used to produce a new value. To do this, there are different types of values involved in an expression. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started The tips and tools in these free tutorials include little known "backdoor" adjustments for everything from reducing workbook and worksheet frustration to hacking built-in features such as pivot tables, charts, formulas and functions, and even the macro language. Site: www.brainbell.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula In Excel there is a help tool for functions called the Function Wizard. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula A date is a number that represents the number of days that have elapsed from a set period in history. Learn how Microsoft Excel uses natural numbers to represent a date. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula A series or collection-based function is one that operates on a group of values. The values are stored in a collection called an array. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula There are many functions built into many spreadsheets. One of the first ones that we are going to discuss is the Average function. The average function finds the average of the specified data. (Simplifies adding all of the indicated cells together and dividing by the total number of cells.) Site: www.usd.edu
|
||
|
|
Site Search
Categories
Adobe Fireworks
Adobe Flash
Adobe Illustrator
Adobe Image Ready
Adobe Photoshop
3D Studio Max
Cinema 4D
Maya 3D
Microsoft Excel
Microsoft PowerPoint
Microsoft Word
Microsoft Access
MySQL
C and C++ 
Python
Visual Basic
.htaccess
Adobe DreamWeaver
ASP
CGI & Perl
CSS
Java
JavaScript
Microsoft FrontPageAdvertisement
|
|