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…

What Does Dmax Function Do ?
This function examines a list of information and produces the largest value from a specified column.

Syntax
=DMAX(DatabaseRange,FieldName,CriteriaRange)
The DatabaseRange is the…

What Does Doller Function Do?
This function converts a number into a piece of text formatted as currency.

Syntax
=DOLLAR(Number,DecimalPlaces)
Number : This is the number which needs to be converted.
DecimalPlaces…

What Does Dsum Function Do ?
This function examines a list of information and produces the total.

Syntax
=DSUM(DatabaseRange,FieldName,CriteriaRange)
The DatabaseRange is the entire list of information you need to examine, including the field names at the…

What Does Edate Formula Do?
This function is used to calculate a date which is a specific number of months in the past or in the future.

Syntax
=EDATE(StartDate,Months)

Formatting
The result will normally be expressed as a number, this can be formatted…

What Does EOMONTH function Do?
This function will show the last day of the month which is a specified number of months before or after a given date.

Syntax
=EOMONTH(StartDate,Months)

Formatting
The result will normally be expressed as a number, this can…