Posted on 08 July 2009
Array formulas help you turn normal Excel Formulas into super formulas. Here are a few examples of
Array formulas. These examples highlight the use of multiple conditions within a single array formula and how we can club multiple formulas in to a single array formula.
Array formulas are powerful - no doubt about that. However before we go any further, one must look at the flip side to using array formulas. They take much more computational power and can slow ...
Continue Reading
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
Posted on 23 August 2008
If you have followed this till now (silly me, if you’re reading this, you likely might’ve :-)), you’ve completed the first of the three important phases in the development of your dashboard. You may want to use these formulas to get your data up to scratch for the next important step – Data Modeling and the generation of pivot tables.
Generating a Pivot Table
Once your data has been properly scrubbed, cleaned for errors and filled up, its time to us ...
Continue Reading
Posted on 23 August 2008
60 useful excel formulas that are a good to know
DATE = Returns the serial number of a particular date
DATEVALUE = Converts a date in the form of text to a serial number
DAY = Converts a serial number to a day of the month
EOMONTH = Returns the serial number of the last day of the month before or after a specified number of months
MONTH = Converts a serial number to a month
NOW = ...
Continue Reading
Posted on 23 August 2008
20 Excel formulas you should know
DATEVALUE = Converts a date in the form of text to a serial number
DAY = Converts a serial number to a day of the month
MONTH = Converts a serial number to a month
YEAR = Converts a serial number to a year
LEFT = Returns the leftmost characters from a text value
LEN = Returns the number of characters in a text string
RIGHT = Returns the rightmost characters from ...
Continue Reading