"INT" Function In Excel
This function rounds the number to its nearest Whole Number. Syntax: =INT(num) Example: The Table has some Numbers, and In the right...
top of page
The Project Management Blog
DPTutorials
Learning Made Easy...
Search
Dp
May 1, 20181 min read
"IF" Function In Excel
This function tests a condition / Logic If the condition is met it is considered to be TRUE.If the condition is not met it is considered...
Dp
May 1, 20181 min read
"HLOOKUP" Function In Excel
This function scans across the column headings at the top of a table to find a specified item.When the item is found, it then scans down...
Dp
May 1, 20181 min read
"FREQUENCY" Function In Excel
This function compares a range of data against a list of intervals.The result shows how many items in the range of data fall between the...
Dp
May 1, 20181 min read
"FORECAST" Function In Excel
This function uses two sets of values to predict a single value.The predicted value is based on the relationship between the two original...
Dp
May 1, 20181 min read
"FIND" Function In Excel
This function looks for a specific letter in a word and gives the result as number of the position of the letter in a word. If the text...
Dp
May 1, 20181 min read
"EOMONTH" Function In Excel
This function will show the last day of the month which is a specified number of months before or after a given date. Syntax:...
Dp
May 1, 20181 min read
"DMAX" Function In Excel
This function examines a list of information and produces the largest value from a specified column. Syntax: =DMAX(DatabaseRange,FieldNam...
Dp
Apr 30, 20181 min read
"RANK" Function In Excel
This Function calculates the position of a value in a list relative to the other values in the list. It can be very much used while...
Dp
Apr 29, 20181 min read
"RAND" Function In Excel
This Function creates a random number between the given two numbers. The Number will change each time the worksheet recalculates or when...
Dp
Apr 29, 20181 min read
"QUOTIENT" Function In Excel
This Function calculates the number of times a number can be divided by another number. It ignores any remainder. Syntax:...
Dp
Apr 29, 20181 min read
"PROPER" Function In Excel
This function converts the first letter of each word to uppercase, and all subsequent Letters are converted to lower case. Syntax:...
Dp
Apr 29, 20181 min read
"PRODUCT" Function In Excel
This Function multiples a group of numbers together. It is the same as using 2*3*4*5, which results the product of the four numbers....
Dp
Apr 29, 20181 min read
"POWER" Function In Excel
This Function raises a number to a user specified power.It is same as using the 6 Operator, Such as 2^5, which results as 32. Both the...
Dp
Apr 29, 20181 min read
"PERMUT" Function In Excel
This Function calculates the maximum number of permutations given a fixed number of items. The Internal order is Significant. so AB and...
Dp
Apr 29, 20181 min read
"ODD" Function In Excel
This Function rounds a number up to the next highest odd number. Syntax: =ODD(number to be Rounded) Example: Here is the detailed video...
Dp
Apr 29, 20181 min read
"NOW" Function In Excel
This Function Shows the Current Date And Time. The Result will be updated each time the Worksheet is opened and Every time an Entry is...
Dp
Apr 29, 20181 min read
"NOT" Function In Excel
This function performs a test to see if the test fails. (A type of reverse logic). If the test fails, the result is TRUE. If the test is...
Dp
Apr 29, 20181 min read
"NETWORKDAYS" Function In Excel
This function will calculate the number of working days between two dates. You can simply use the subtraction method but the Benefit of...
Dp
Apr 29, 20181 min read
"N" Function In Excel
This function converts a numeric entry to its mathematical value.Anything which will not convert is shown as 0 zero.Excel does not really...
bottom of page