DPTutorials

This function converts a value measure in one type of unit, to the same value expressed in a different type of unit, such as Inches to...

This function counts the number of items which match criteria set by the user. Syntax =COUNTIF(RangeOfThingsToBeCounted,CriteriaToBeMatch...

This function joins separate pieces of text into one item. Syntax: =CONCATENATE(Text1,Text2,Text3...Text30) Example: Here is the video...

This function removes any nonprintable characters from text. These nonprinting characters are often found in data which has been imported...

This function calculates the highest number of combinations available based upon a fixed number of items. This is nothing but the...

This function calculates the average from a list of numbers. If the cell contains zero 0, the cell will be included in the average...

This function tests two or more conditions to see if they are all true. It can be used to test that a series of numbers meet certain...

A formula is an expression which calculates the value of a cell. Whereas the function is the predefined formula readily available in MS...