Formulas 3/3

Apr 22, 20181 min read

"Convert" function in Excel

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...

Apr 22, 20181 min read

"COUNTIF" Function In Excel

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

Apr 22, 20181 min read

"Concatenate" Function In Excel

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

Apr 22, 20181 min read

"Clean" Function In Excel

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

Apr 22, 20181 min read

"Combin" Function In Excel

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

Apr 22, 20181 min read

"Average" Function in Excel

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

Apr 22, 20181 min read

"AND" Function in Excel

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...

Apr 20, 20181 min read

Formulae and Functions in Excel

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

The Project Management Blog