Excel AND Function
Wednesday October 8, 2008
Excel Spreadsheet AND Function
© Ted French
The AND function allows you to specify up to 255 criteria to be evaluated. All of these criteria would need to meet the specified criteria for the function to give you a True response.
As with the OR function, the AND function, by itself, has limited usefulness. When by combining it with another function, such as the IF function, the AND function can greatly increase the capabilities of your spreadsheet.
To find out how to use this function, read this short article on the Excel AND Function.
Related Articles
Excel 2007 OR Function
Sunday October 5, 2008
The OR function is one of Excel's Logical Functions. What a logical function does is evaluate the data in a certain cell to see if it meets specified criteria. If it does, the function returns a True response in the cell where the function is located. If not, a False statement is returned.
In Excel 2007, the OR function allows you to specify up to 255 criteria to be evaluated. If any of these criteria meet the specified criteria the function returns a True response.
By itself, the OR function has limited usefulness, but, by combining it with another function, such as the IF function, the OR function can greatly increase the capabilities of your spreadsheet.
To find out how to use this function, read this short article on the Excel 2007 OR Function.
Related Articles
In Excel 2007, the OR function allows you to specify up to 255 criteria to be evaluated. If any of these criteria meet the specified criteria the function returns a True response.
By itself, the OR function has limited usefulness, but, by combining it with another function, such as the IF function, the OR function can greatly increase the capabilities of your spreadsheet.
To find out how to use this function, read this short article on the Excel 2007 OR Function.
Related Articles
Nested IF Functions in Excel
Wednesday October 1, 2008
Believe it or not some people shy away from using the IF function because of its apparent complexity. In doing so, they are missing out on one of the most useful functions available in spreadsheet programs like Excel.
Using the IF function adds flexibility to a spreadsheet by introducing decision making. What the IF function does is test to see if a certain condition is true or false. If it is true, the function enters one result in a specific cell. If the condition is false, it enters a different result into that cell.
To further increase the flexibility of your spreadsheets, it is possible to Nest or place one IF function inside another.
To find out how to do this, read the article on Nested IF Functions in Excel.
Related Articles
Using the IF function adds flexibility to a spreadsheet by introducing decision making. What the IF function does is test to see if a certain condition is true or false. If it is true, the function enters one result in a specific cell. If the condition is false, it enters a different result into that cell.
To further increase the flexibility of your spreadsheets, it is possible to Nest or place one IF function inside another.
To find out how to do this, read the article on Nested IF Functions in Excel.
Related Articles
Excel IF Function
Monday September 29, 2008
Excel IF Function
© Ted French
The IF function works by testing to see if a certain condition is true. If it is, the function enters one result in a specific cell, if it is not; it enters a different result in that cell.
The number of possible outcomes from the IF function can be increased by "nesting" one IF function inside another.
To find out more about this wonderful spreadsheet feature, watch the video on the Excel IF Function.
Related Articles
Excel 2007 COUNTIFS Function
Saturday September 27, 2008
Excel 2007's COUNTIFS function is similar to the COUNTIF function except that it is used to find out the number of times the data in two or more ranges of cells meets specific criteria.
For example, the function can be used to evaluate multiple lists of phone numbers to see how many of these entries match specific numbers.
To find out the details, read the article on using the Excel 2007 COUNTIFS Function.
Related Articles
For example, the function can be used to evaluate multiple lists of phone numbers to see how many of these entries match specific numbers.
To find out the details, read the article on using the Excel 2007 COUNTIFS Function.
Related Articles
Excel 2007 SUMIF
Thursday September 25, 2008
Two of the most useful functions available in Excel are the IF function and the SUM function:
SUMIF makes it easier to add up values if a certain criterion is met. The criterion can test the data to be summed or an entirely different range of data.
To find out more, read the short article on the Excel 2007 SUMIF function.
Related Articles
- The IF function introduces decision making which adds flexibility to your to spreadsheets.
- The SUM function makes it easy to add up data located in rows or columns.
SUMIF makes it easier to add up values if a certain criterion is met. The criterion can test the data to be summed or an entirely different range of data.
To find out more, read the short article on the Excel 2007 SUMIF function.
Related Articles
Excel 2007 AVERAGEIF
Tuesday September 23, 2008
One of Excel's Something - If functions is the AVERAGE IF function.
AVERAGE IF combines two very useful and well used functions - the IF function and the AVERAGE function.
The IF function introduces decision making to your spreadsheets. The AVERAGE function is used to find the average value in a range of data.
AVERAGE IF makes it easier to find the average value if specific criteria are met. This makes it possible to set up trigger cells in a spreadsheet so that the data is averaged only when a certain level is reached.
To find out more, read the short article on the Excel 2007 AVERAGEIF function.
Related Articles
AVERAGE IF combines two very useful and well used functions - the IF function and the AVERAGE function.
The IF function introduces decision making to your spreadsheets. The AVERAGE function is used to find the average value in a range of data.
AVERAGE IF makes it easier to find the average value if specific criteria are met. This makes it possible to set up trigger cells in a spreadsheet so that the data is averaged only when a certain level is reached.
To find out more, read the short article on the Excel 2007 AVERAGEIF function.
Related Articles
Excel 2007 QUOTIENT Function
Sunday September 21, 2008
The QUOTIENT function is another of Excel's functions that can be used to carry out mathematical operations in a spreadsheet.
In particular, the QUOTIENT function provides a way to divide numbers in a spreadsheet without having to create formulas all the time.
One characteristic of the QUOTIENT function, however, is that it discards any remainder and only shows the integer or whole number as the answer. The function, therefore, can't be used in place of all division operations.
To find out how more about this function, read the article on Excel 2007 Quotient Function.
Related Articles
In particular, the QUOTIENT function provides a way to divide numbers in a spreadsheet without having to create formulas all the time.
One characteristic of the QUOTIENT function, however, is that it discards any remainder and only shows the integer or whole number as the answer. The function, therefore, can't be used in place of all division operations.
To find out how more about this function, read the article on Excel 2007 Quotient Function.
Related Articles
Excel 2007 PRODUCT Function
Thursday September 18, 2008
Excel PRODUCT function
© Ted French
In particular, the PRODUCT function provides a quick way to multiply numbers without having to create formulas all the time.
It can be used, for example, where the results of scientific experiments need to be multiplied by a constant value. It could also be used in a spreadsheet with payroll information where multiplication operations are used to find the amounts of various deductions.
To find out more about this function, read the article on the Excel 2007 PRODUCT Function.
Related Articles
Excel’s Format Painter
Tuesday September 16, 2008
One of the features I really like in Excel, and one that I use frequently is the format painter. My affection for this feature stems from how easy it is to use, and how quickly it allows you to add formatting options to a spreadsheet.
What format painter allows you to do is, with the single click of the icon, copy all the formatting options from one cell and paste them into another cell or cells in a spreadsheet. The cells don't even need to be adjacent to each other when you do this.
In versions of Excel 97 through to 2003, format painter can be found on the Standard toolbar. In Excel 2007, it is located on the Home tab of the ribbon menu. To find out how using this feature can simplify formatting a spreadsheet, read the article on Excel’s Format Painter.
Related Articles
What format painter allows you to do is, with the single click of the icon, copy all the formatting options from one cell and paste them into another cell or cells in a spreadsheet. The cells don't even need to be adjacent to each other when you do this.
In versions of Excel 97 through to 2003, format painter can be found on the Standard toolbar. In Excel 2007, it is located on the Home tab of the ribbon menu. To find out how using this feature can simplify formatting a spreadsheet, read the article on Excel’s Format Painter.
Related Articles