The NOT function, one of many EXCEL logical functions, is used to evaluate a single logical condition, passed as an argument to the function. It will return the opposite of that argument. I.e.:
If the evaluated logical condition is TRUE, the function will return FALSE.
If the evaluated logical condition is FALSE the function will return TRUE.
Syntax
NOT(logical)
Logical is [...]
The OR function , one of many EXCEL logical functions, is used to evaluate a number of logical conditions, passed as arguments to the function. The function will return a single value of TRUE or FALSE.
Syntax
OR(logical1, logical2 ………)
logical1 and logical2 are conditions that evaluate to TRUE or FALSE. The first argument is required the second [...]
The AND function , one of many EXCEL logical functions, is used to evaluate a number of logical conditions, passed as arguments to the function. The function will return a single value of TRUE or FALSE.
Syntax
AND(logical1, logical2 ………)
logical1 and logical2 are conditions that evaluate to TRUE or FALSE. The first argument is required the second [...]
The IF function, one of many EXCEL logical functions, is used to evaluate a logical condition, passed as an argument to the function. The function will then return one of two values specified as the second argument or the third argument in the function. It will return the second argument if the test evaluates to [...]
To sum times you usually use Excel built-in function SUM. If you have three cells A1, A2 and A3 formatted as time (hh:mm), and you have :
A1 = 02:30
A2 = 10:15
A3 has the formula: =SUM(A1:A2)
then A3 will have the correct values of 12:45.
However if your total times are greater than 24 hours then things get [...]
One of the newly introduced functions in Excel 2007 is the IFERROR Function. If you are using a formula in a cell, this function allows you to trap formula errors and specify a value to be substituted in the cell in case of an error.
Syntax
IFERROR(value,value_if_error)
Value is the argument (formula) that is checked for an error.
Value_if_error [...]
I find it annoying sometimes when I enter a correct formula in a cell and Excel gives me an error like “Inconsistent Formula” or “Formula Omits Adjacent Cells”.
Fortunately you can hide these error indicators through Excel Options.
Click the Microsoft Office button.
Click Excel Options.
In the left pane of Excel Options click Formulas.
In the Error Checking [...]
To find cells that meet a specific criteria, for example cells with conditional formatting or cells which have data validation, proceed as follows:
In the Home tab Editing group click Find and Select.
Click on:
Formulas : to find cells that contain formulas.
Comments : to find cells that contain comments.
Conditional Formatting : to find cells that have [...]
In an earlier post I demonstrated How to sum cells with multiple criteria in Excel 2003. I used an Array Formula consisting of the SUM function and the IF function.
In Excel 2007 however a new function is introduced that facilitates sum with multiple criteria: the SUMIFS function.
Syntax
SUMIFS (sum_range, criteria_range1, criteria1, criteria range2, criteria2…) … up [...]
To calculate a running average, or a moving average, for a range of cells (a column), you use the AVERAGE function. The only trick you need to apply is to make your range changing continuously.
In the example below we want to calculate the running average of the sales from January to June.
Our ranges for the [...]
