Function: CEILING.MATH

Function: CEILING.MATH

The CEILING MATH (CEILING.MATH) is a Math function that rounds a given number up to the nearest multiple of significance. This function has been released with 2013 version as a replacement for the CEILING function. In this guide, we’re going to show you how to use the...
Function: FLOOR.MATH

Function: FLOOR.MATH

The FLOOR MATH (FLOOR.MATH) function is a Math formula that rounds a given number down to the nearest multiple of significance. This function was released in Excel 2013 as a replacement for the FLOOR function. In this guide, we’re going to show you how to use the...
Function: INT

Function: INT

The Excel INT function is a Math formula that rounds a given number down to the nearest integer. Although, it is similar to the TRUNC function, they work differently when working with negative numbers. In this guide, we’re going to show you how to use the INT function...
Function: TRUNC

Function: TRUNC

The Excel TRUNC function is a Math formula that truncates a given number by removing a number of digits. Although, it is similar to the INT function, the TRUNC function works differently when truncating negative numbers. In this guide, we’re going to show you how to...
Function: COUNTBLANK

Function: COUNTBLANK

The Excel COUNTBLANK function is a Statistical formula that counts the empty cells in a given range. It can be especially useful in data analysis and organization tasks, where you need to find out any errors or fields that require attention. In this guide, we’re going...
Function: REPT

Function: REPT

REPT is a Text function that repeats a string a given number of times. It is useful for filling a cell or fixed length of strings, as well as creating simple histograms. In this guide, we’re going to show you how to use REPT function and also go over some tips and...
Function: MEDIAN

Function: MEDIAN

The MEDIAN Excel function is a Math formula that calculates and returns the median of the selected values. The median in statistics represents the middle value in a dataset. In this guide, we’re going to show you how to use the Excel MEDIAN function and also go over...
Function: TRANSPOSE

Function: TRANSPOSE

The TRANSPOSE Excel function is a Lookup & Reference formula that rotates a given range or array. Since the output of this formula is an array, you need to press the Ctrl + Shift + Enter (CSE) key instead of just pressing the Enter key when entering this function....