Mohammed Fahim

Certified Spreadsheet Expert. I love creating ready-to-use templates in Utility programs like Microsoft Office, OpenOffice, Google Docs Editor Suite, and iWork Suite.

CONCATENATE Function

CONCATENATE Function: Excel, Sheets, Calc & Numbers

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 […]

CONCATENATE Function: Excel, Sheets, Calc & Numbers Read More »

AVERAGE Function: Excel, Sheets, Calc & Numbers

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

AVERAGE Function: Excel, Sheets, Calc & Numbers Read More »

CEILING Function

CEILING Function: Excel, Sheets, Calc & Numbers

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.

CEILING Function: Excel, Sheets, Calc & Numbers Read More »

Exit mobile version