"MROUND" Function In Excel
This Function Rounds a number up or down to the nearest multiple specified by the user. Syntax: =MROUND(NumberToRound,MultipleToUse)...
top of page
The Project Management Blog
DPTutorials
Learning Made Easy...
Search
Dp
Apr 29, 20181 min read
"MOD" Function In Excel
This function calculates the remainder after a number has been divided by another number. Syntax: =MOD(Number,Divisor) Example: Here is...
Dp
Apr 29, 20181 min read
"MIN" Function In Excel
This Function Results the Lowest value of the data given. Syntax: =MIN(Range1,Range2,Range3... through to Range30) Example: In the...
Dp
Apr 29, 20181 min read
"MID" Function In Excel
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...
Dp
Apr 29, 20181 min read
"MAX" Function In Excel
This Function picks the highest value from the given list of values. Syntax: =MAX(Range1,Range2,Range3... through to Range30) Example:...
Dp
Apr 29, 20181 min read
"MATCH" Function In Excel
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...
Dp
Apr 29, 20181 min read
"LOWER" Function In Excel
This Function converts your Uppercase sentence text into lower case one Syntax: =LOWER(TextToConvert) Example: Here is the video tutorial...
Dp
Apr 29, 20181 min read
"LOOKUP" Function In Excel
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...
Dp
Apr 29, 20181 min read
"DAVERAGE" Function In Excel
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...
Dp
Apr 28, 20181 min read
"DATEDIF" Function In Excel
This function calculates the difference between two dates. It can show the result in weeks, months or years. Syntax:...
Dp
Apr 27, 20181 min read
"COUNTBLANK" Function in Excel
This function counts the number of blank cells in a range. Syntax: =COUNTBLANK(RangeToTest) Example: Here is the video tutorial of the...
Dp
Apr 26, 20181 min read
"LEFT" Function In Excel
This function displays a specified number of characters from the left hand side of a given word. Syntax: =LEFT(OriginalText,NumberOfChara...
Dp
Apr 25, 20181 min read
"LCM" Function In Excel
This Function calculates the Least Common Multiple of Given Numbers. LCM is nothing but the Least number which can be divided with the...
Dp
Apr 24, 20181 min read
"DAY" Function in Excel
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...
Dp
Apr 24, 20181 min read
"DATE" Function In Excel
This function creates a real date by using three normal numbers typed into separate cells. Syntax: =DATE(year,month,day) Example: Here is...
Dp
Apr 23, 20181 min read
"COUNTIFS" Function In Excel
This function counts the number of items which match multiple criterias set by the user. Syntax =COUNTIFS(RangeOfThings,Criteria1ToBeMat...
Dp
Apr 23, 20181 min read
"LARGE" Function In Excel
This function Recognizes the List of Values and picks up a value according to the user specified position of the values arranged in the...
Dp
Apr 22, 20181 min read
COUNTA function in Excel
This function counts the number of numeric or text entries in a list. It will ignore only blanks. Syntax: =COUNTA(Range1,Range2,Range3......
Dp
Apr 22, 20181 min read
"COUNT" Function In Excel
This function counts the number of numeric entries in a list. It will ignore blanks, text and errors. Syntax: =COUNT(Range1,Range2,Range3...
Dp
Apr 22, 20181 min read
"Correl" Function in Excel
This function examines two sets of data to determine the degree of relationship between the two sets.The result will be a decimal between...
bottom of page