What Does BIN2DEC Do ?

This function converts a binary number to decimal.
Negative numbers are represented using two's-complement notation.

Syntax
=BIN2DEC(BinaryNumber)
The binary number has a limit of ten characters.

Support our work by doing the following…

Sometimes you will need to use brackets, (also known as 'braces'), in formula.
This is to ensure that the calculations are performed in the order that you need.
The need for brackets occurs when you mix plus or minus with divide or multiply.

Mathematically…

What Does Ceiling Function Do ?
This function rounds a number up to the nearest multiple specified by the user.

Syntax
=CEILING(ValueToRound,MultipleToRoundUpTo)
The ValueToRound can be a cell address or a calculation.

Support our work by doing the following…

What Does Cell Function Do ?
This function examines a cell and displays information about the contents, position and formatting.

Syntax
=CELL("TypeOfInfoRequired",CellToTest)
The TypeOfInfoRequired is a text entry which must be surrounded with quotes " ".…

What Does Char Function Do?
This function converts a normal number to the character it represent in the ANSI
character set used by Windows.

Syntax
=CHAR(Number)
The Number must be between 1 and 255.

Support our work by doing the following :
1. Like the…

What Does Choose Function Do?
This function picks from a list of options based upon an Index value given to by the user.

Syntax
=CHOOSE(UserValue, Item1, Item2, Item3 through to Item29)

#choosefunction
#chooseformula
#excelformula
#exceltips
excel formulas…

What Does Concatenate Function Do?
This function joins separate pieces of text into one item.

Syntax
=CONCATENATE(Text1,Text2,Text3...Text30)
Up to thirty pieces of text can be joined.

Formatting
No special formatting is needed, the result will be shown…

What Does Convert Function Do ?
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 Centimetres.

Syntax
=CONVERT(AmountToConvert,UnitToConvertFrom,UnitToConvertTo)

Formatting…

What Does Count Formula Do ?
This function counts the number of numeric entries in a list.
It will ignore blanks, text and errors.

Syntax
=COUNT(Range1,Range2,Range3... through to Range30)

Formatting…

What Does Counta Function Do ?
This function counts the number of numeric or text entries in a list.
It will ignore blanks.

Syntax
=COUNTA(Range1,Range2,Range3... through to Range30)

Formatting
No special formatting is needed.

Support our work by doing…

What Does Clean Function Do?

This function removes any nonprintable characters from text.

These nonprinting characters are often found in data which has been imported from other systems such as database imports from mainframes.

Syntax
=CLEAN(TextToBeCleaned)…

What Does Code Function Do?
This function shows the ANSI value of a single character, or the first character in a piece of text.
The ANSI character set is used by Windows to identify each keyboard character by using a unique number.
There are 255 characters…

What Does Countif Function Do ?
This function counts the number of items which match criteria set by the user.

Syntax
=COUNTIF(RangeOfThingsToBeCounted,CriteriaToBeMatched)
The criteria can be typed in any of the following ways.
To match a specific number…

What Does Date Function Do?
This function creates a real date by using three normal numbers typed into separate cells.

Syntax
=DATE(year,month,day)

Formatting
The result will normally be displayed in the dd/mm/yy format.
By using the Format,Cells,Number…

What Does Datedif Formula Do?
This function calculates the difference between two dates.
It can show the result in weeks, months or years.

Syntax
=DATEDIF(FirstDate,SecondDate,"Interval")
FirstDate : This is the…

Support our work by doing the following :
1. Like the videos.
2. Comment on the videos giving suggestions for other videos.
3. Share the Videos Uploaded on this YouTube Channel with your friends and Family.
4. Facebook : https://www.facebook.com/ManzilInstitute/…

Support our work by doing the following :
1. Like the videos.
2. Comment on the videos giving suggestions for other videos.
3. Share the Videos Uploaded on this YouTube Channel with your friends and Family.
4. Facebook : https://www.facebook.com/ManzilInstitute/…

Support our work by doing the following :
1. Like the videos.
2. Comment on the videos giving suggestions for other videos.
3. Share the Videos Uploaded on this YouTube Channel with your friends and Family.
4. Facebook : https://www.facebook.com/ManzilInstitute/…

What Does DB Function Do ?
This function calculates deprecation based upon a fixed percentage.
The first year is depreciated by the fixed percentage.
The second year uses the same percentage, but uses the original value of the item less the first years depreciation.…

What Does Delta Formula Do ?
This function compares two values and tests whether they are exactly the same.
If the numbers are the same the result will be 1, otherwise the result is 0.
It only works with numbers, text values…