Excel RAND RANDBETWEEN Function to generate random number

Posted on January 12, 2015March 27, 2015 by Wyman W

This Excel tutorial explains how to use Excel RANDBETWEEN Function and Excel RAND Function to generate random number and explain the difference. Excel RAND RANDBETWEEN Function - generate random number Before Excel 2007, Excel uses RAND Function to generate a random number that is greater than zero and smaller than 1. Since Excel 2007, a new Function RANDBETWEEN was added, it is used to generate a random integer between two desired integers. Note that RANDBETWEEN and RAND Functions are...

Excel IFERROR Function

Posted on January 7, 2015December 16, 2015 by Wyman W

This Excel tutorial explains how to use Excel IFERROR function for worksheet. IFERROR can be used with vlookup to capture ISNA error. You may also want to read: Check Excel #N/A using ISNA Function What is Excel IFERROR Function? Excel IFERROR Function is an error handling function, if an "Error" is found, then a desired value is returned. This is a new function introduced in Excel 2007, which means Excel 2003 and prior versions cannot be used. Syntax of IFERROR IFERROR(value,value_if...

Excel SUMIFS Function

Posted on January 7, 2015 by Wyman W

What is Excel SUMIFS Function? Excel SUMIF Function sum up an array (a range of values) if condition is met. Excel SUMIFS function is an advanced version of SUMIF, allow you to set multiple conditions. If you only need to apply one criteria, please read the use of SUMIF Excel SUMIF Function Syntax of Excel SUMIFS Function SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2, ... criteria_range_n, criteria_n] ) sum_range The actual cells to add, if you wa...

Excel SUMIF Function

Posted on January 7, 2015February 28, 2015 by Wyman W

What is Excel SUMIF Function? Excel SUMIF Function sum up an array (a range of values) if condition is met. Note that you can set only one condition, for multiple conditions you need the SUMIFS Function (with "s" in suffix) Read the below article about SUMIFS Function Excel SUMIFS Function Syntax of Excel SUMIF Function SUMIF( range, criteria, [sum_range] ) range The range of cells that you want evaluated by criteria. Cells in each range must be numbers or names, arrays, or refe...

Excel Networkdays function to exclude weekend

Posted on December 26, 2014March 1, 2015 by Wyman W

This tutorial explains how to use Excel Networkdays Function to exclude weekend and holiday. Excel Networkdays function to exclude weekend and holiday Excel Networkdays Function literally means "net working days", which calculates the number of days between two specific days, excluding weekend (Saturday and Sunday) and holiday. Both start date and end date inclusive. For example, from Jan 1st, 2015 (Thu) to Jan 5th, 2015 (Monday), total number of Networkdays is three. The function counts...

Excel Round Function

Posted on December 26, 2014March 7, 2015 by Wyman W

This tutorial explains how to use Excel Round Function Excel Round Function There are several kinds of Rounding in Excel - Round, Round up, Round down, Mround, plus Banker's Rounding in VBA. Excel Round Function is the most commonly used round, it uses "round half to up" logic, round up if the decimal part >=0.5, round down if decimal part <0.5 Syntax of Excel Round Function ROUND( number, digits ) number The number you want to apply rounding digits An integer that ...

Excel COUNTA Function to count non-empty cells

Posted on December 24, 2014October 16, 2015 by Wyman W

What does Excel COUNTA Function do? Excel COUNTA Function is used to count non-empty cells in the specified range, regardless whether it is text, space, date or number. Unlike COUNT Function, which only counts "number". Read the below article for explanation of COUNT function. Excel worksheet COUNT function Why do you need Excel COUNTA Function? Normally, it is used to count non-empty cells, but it is more commonly used to determine the last row in the column. For example, assume that ...

Excel COUNT Function

Posted on December 24, 2014January 7, 2015 by Wyman W

What does Excel COUNT Function do? Excel COUNT function is used to count how many "number" in the specified range. Note that "number" in text format (with the green triangle on the top left) is not counted. It can be used to count non-empty cells in a column that contains number. You can also read the below article that explains COUNTA Function, which counts non-empty values regardless of numeric or text. Excel worksheet COUNTA Function Syntax of Excel COUNT Function =COUNT(value...

Excel OFFSET Function for worksheet

Posted on December 23, 2014January 9, 2015 by Wyman W

What is Excel OFFSET Function? Excel OFFSET Function returns the Range object which is number of rows and columns away from a specific range. You can specify to shift up, down, left or right from a cell. For example, if column A contains employee ID, and column B contains employee name, you can find the employee name in B2 by shifting A2 to the right. (shift 1 column to the right and shift 0 row). The advantage of using OFFSET property is that even when the actual column change, you don't ...

Excel DATEDIF Function to calculate date difference

Posted on December 8, 2014July 7, 2017 by Wyman W

This tutorial explains how to use Excel DATEDIF Function to calculate date difference (difference between two dates) in complete year, month or day. You may also want to read: Access Excel VBA day month year difference between two dates Excel DATEDIF Function DATEDIF function stands for "Date Difference". It calculates the difference between two dates in complete year, month or day. Note that DATEDIF Function returns the "complete" value, for example, if the year difference between two d...