Tag: Excel formula

How to use LOWER Function in Excel

Excel Lower Function Converts all uppercase letters in a text string. This function does not affect numbers, punctuation and spaces. There is no difference in the result when Excel cell…

How to use AVERAGE Function in Excel.

This function calculates the average from a list of numbers. Arguments can either be numbers or names, ranges, or cell references that contain numbers.Logical values and text representations of numbers…

How to use ADDRESS Function in Excel

The ADDRESS function to obtain the address of a cell in a worksheet, returns the address for a cell based on a given row and column number. For example, ADDRESS(4,2)…

How to use ACOT function in excel

The Excel ACOT function calculates the arc-cotangent (or inverse cotangent) of a given number, and returns an angle, in radians, between 0 and π.

How to use ABS Function in excel

The Excel ABS function returns the absolute value of a number. Negative numbers are converted to positive numbers.