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...
Read More
function
Excel COUNTA Function to count non-empty cells
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 ...
Read More
Excel COUNT Function
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...
Read More
Excel OFFSET Function for worksheet
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 ...
Read More
Excel VBA OFFSET Property for Range
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 ...
Read More