

Here, in our example, the number was created with the COLUMN function, which returned the column number of cell B8, the number 2, minus 1, which is supplied as an “offset.” Why did we use an offset? It is because we wanted to make sure that Excel starts counting at 1, regardless of the actual column number. The function is useful for formulas that are required to do a specified act every nth time.
#Adding a fx equation in excel mobile mod
Here, two formulas are used: MOD and COLUMN. The formula can also be used for a fixed expense every regular time interval, a fixed payment every 6 months such as premiums, etc. If we wish to get it once in 2 months, then we will change the formula to: So, in the example above, we took a recurring expense at every 3 months. If we wish to generate a fixed value every third month, we can use a formula based on the MOD function. Suppose a flower expense is payable every third month. When we used the reference B6, it returned the result of 3 as the column reference was B.Īs you can see above, when we provide an array, the formula returned a result of 3. In the first reference that we’ve provided, we did not give a reference so it gave us the result 4 with the COLUMN function in cell C5, as shown in the screenshot below: Suppose we are given the following references:

To understand the uses of the COLUMN Function in Excel, let’s consider a few examples: Example 1 It is a built-in function that can be used as a worksheet function in Excel. We cannot include multiple references or addresses as reference for this function.If not provided by us, then it will default to the cell in which the column function exists.Reference can be a single cell address or a range of cells.The function will give us a numerical value.Ī few points to remember for the reference argument: It is the cell or a range of cells for which we want the column number. The COLUMN function uses only one argument – reference – which is an optional argument. For example, the formula =COLUMN(A10) returns 1, because column A is the first column. This function is useful for looking up and providing the column number of a given cell reference. The COLUMN Function in Excel is a Lookup/Reference function.

Updated JWhat is the COLUMN Function in Excel?
