Posted on 05 July 2009
Array Formulas in Excel
An Array Formula in excel is a formula that uses arrays instead of single cell value as input.
Excel Array Formulas can be thought of as many formulas packed into a single super formula. In this article we will take a look at the syntax of an array formula, its various parts, learn how to write a basic array formula and then graduate on to writing the more powerful versions of it. Before we begin, let ...
Continue Reading
Posted on 04 July 2009
IF formula in Excel checks whether a given condition evaluates TRUE or FALSE.
Syntax of IF Formula
Example of IF Formula
Possible Errors returned by the IF Formula
IF Formula Syntax
IF Formula has three parts:
IF(criteria, value_when_true, value_when_false)
criteria
criteria is the condition that we would like to evaluate for being TRUE or FALSE.
value_when_true
value_when_true is the value that will be returned by the function when the above criteria evaluates to TRUE. This ...
Continue Reading