Posted on

## MAX LARGE MAXIFS MIN SMALL MINIFS functions in Excel

These functions will find the biggest (smallest) numbers in a range of data set. you can find 1st, 2st and .. number in your range

Posted on

## VARIANCE and STANDARD DEVIATION in Excel

Standard deviation is a number that measures the variation among data. And its mean that how much data are far from their mean

Posted on

## ROUND ROUNDUP ROUNDDOWN functions in Excel

These functions will convert a decimal number into an integer or another decimal number with desired decimal point

Posted on

## RAND and RANDBETWEEN functions in Excel

These two functions will return the a random number in Excel, RAND function will return a decimal random number between 0 to 1 and RANDBETWEEN will return an integer random number between two defined values

Posted on

## SUMIF and SUMIFS Functions in Excel

SUMIF and SUMIFS in Excel
These two functions will return the summation of values in the cells based on the one or more criteria

Posted on

## WeekNum and WeekDay functions in Excel

WEEKDAY, WEEKNUM in Excel These functions will return the week number from the start of year and the day name of the week at specific date