Access Round Function and custom Round Function

This tutorial explains how to use Access Round Function (round to even logic) and create a custom Round Function to simulate Excel Round Function. 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 the integer rounds down. For Access Round Function, as well as Access VBA, Excel VBA, the Round Function uses "Round to even" logic. Integ...
More

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 ...
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...
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 ...
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 ...
More