DPTutorials

This Function Rounds a number up or down to the nearest multiple specified by the user. Syntax: =MROUND(NumberToRound,MultipleToUse)...

This function calculates the remainder after a number has been divided by another number. Syntax: =MOD(Number,Divisor) Example: Here is...

This Function Results the Lowest value of the data given. Syntax: =MIN(Range1,Range2,Range3... through to Range30) Example: In the...

This function picks out a piece of text from the middle of a text entry. The function needs to know at what point it should start, and...

This Function picks the highest value from the given list of values. Syntax: =MAX(Range1,Range2,Range3... through to Range30) Example:...

This function looks for an item in a list and shows its position. It can be used with text and numbers. It can look for an exact match or...

This Function converts your Uppercase sentence text into lower case one Syntax: =LOWER(TextToConvert) Example: Here is the video tutorial...

This function looks for a piece of information in a list of values, and then picks an item from the last cell in the adjacent row or...

This Function is used to find the average of a particular item chosen from a particular criteria This is a combination of IF and Average...

This function calculates the difference between two dates. It can show the result in weeks, months or years. Syntax:...

This function counts the number of blank cells in a range. Syntax: =COUNTBLANK(RangeToTest) Example: Here is the video tutorial of the...

This function displays a specified number of characters from the left hand side of a given word. Syntax: =LEFT(OriginalText,NumberOfChara...

This Function calculates the Least Common Multiple of Given Numbers. LCM is nothing but the Least number which can be divided with the...

This function extracts the day of the month from a complete date. Syntax: =DAY(value) Example: Here is the video tutorial of the same for...

This function creates a real date by using three normal numbers typed into separate cells. Syntax: =DATE(year,month,day) Example: Here is...

This function counts the number of items which match  multiple criterias set by the user. Syntax =COUNTIFS(RangeOfThings,Criteria1ToBeMat...

This function Recognizes the List of Values and picks up a value according to the user specified position of the values arranged in the...

This function counts the number of numeric or text entries in a list. It will ignore only blanks. Syntax: =COUNTA(Range1,Range2,Range3......

This function counts the number of numeric entries in a list. It will ignore blanks, text and errors. Syntax: =COUNT(Range1,Range2,Range3...

This function examines two sets of data to determine the degree of relationship between the two sets.The result will be a decimal between...