CONCATENATE Function in Microsoft Excel, OpenOffice Calc, Google Sheets, and Apple Numbers combines two or more text strings into one string. Important Note: CONCATENATE Function has been replaced in recent versions of Excel with CONCAT Function. Hence, in Excel 2016, Excel Mobile, and Office 365, you need to use the CONCAT Function. No need to […]

The AVERAGE function in Microsoft Excel, OpenOffice Calc, Google Sheets, and Apple Numbers returns the average (arithmetic mean) of the provided arguments. In simple terms, it calculates the central tendency or center of a group of numbers in a statistical distribution. When using the AVERAGE function, the arguments should be numeric values or arrays of

CEILING Function in Microsoft Excel, Google Sheets, OpenOffice Calc, and Apple Numbers returns an integer to a round number to a specific interval or a certain multiple. To use the CEILING function, you’ll need two inputs: the number you want to round up and the significance or multiple to which you want to round it.

MIN Function in Microsoft Excel, Google Sheets, OpenOffice Calc, and Apple Numbers returns the smallest value in a group of numbers. Mathematically, the MIN of any set of numbers is the smallest value in a given range of numbers. For example, 10,23,32,15 are a set of numbers. We can easily spot the smallest number in

MAX Function in Microsoft Excel, Google Sheets, OpenOffice Calc, and Apple Numbers returns the maximum value in a group of numbers. Mathematically, the MAX of any set of numbers is the highest value in a given range of numbers. For example, 10,23,32,15 are a set of numbers. We know that it is 32. Up to