Access Round Function and custom Round Function

Posted on December 26, 2014March 17, 2019 by Wyman W

This tutorial explains how to use Access Round Function (round to even logic) and create a custom Round Function to simulate Excel Round Function. You may also want to read: VBA Excel Access roundup rounddown Function Excel Access MRound custom Function round to nearest multiple Access Round Function - Round to even logic Access Round Function is completely different from Excel Round Function. For Excel Round Function, if decimal part is >=0.5, the integer rounds up, otherwise...

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 VBA OFFSET Property for Range

Posted on December 23, 2014February 26, 2017 by Wyman W

This Excel VBA tutorial explains how to use Excel VBA OFFSET property, and explain difference between VBA OFFSET Property and worksheet OFFSET Function. Excel VBA OFFSET Property Excel VBA OFFSET property 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 ...