Excel Find Formula

Find

In Excel, the Find function returns the location of a substring in a string. The search is case-sensitive.
The syntax for the Find function is:Find( text1, text2, start_position )
text1 is the substring to search for in text2.
text2 is the string to search.
start_position is the position in text2 where the search will start. The first position is 1.
Note:
If the Find function does not find a match, it will return a #VALUE! error.
Applies To:
Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example:
A1 = Alphabet
A2 = alphabet
A3 = Tech on the Net
Based on the Excel spreadsheet above:
=Find("Alpha", A1, 1) would return 1
=Find("alpha", A1, 1) would return #VALUE!
=Find("alpha", A2, 1) would return 1
=Find("the", A3, 3) would return 9
=Find("ph", "Alphabet", 2) would return 3

Source: www.excel-functions.blogspot.com

Read More

For Birth Dates After 1900 Excel Function

To calculate the age of a person on date since their birthdate:=INT((date-birthdate)Applies To:MS Excel 2003,MS Excel 2007,MS Excel 2010
To figure their age as of today, date can be replaced with a function like TODAY() or NOW(). The INT() function is used to return only the number of complete years.

Publisher: http://excel-formulas.blogspot.com/

Read More

Dollar Excel Function

Dollar Excel Function

In Excel, the Dollar function converts a number to text, using a currency format. The format used is $#,##0.00_);($#,##0.00).
The syntax for the Dollar function is:
Dollar( number, decimal places )
number is the number to convert to text.
decimal_places is the number of decimal places to display. The number will be rounded accordingly.
Applies To:
Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example:
A1 = 120.1
A2 = 52

Based on the Excel spreadsheet above:
=Dollar(A1, 0) would return "$120"
=Dollar(A1, 2) would return "$120.10"
=Dollar(A2, 1) would return "$52.1"
=Dollar(1345, 2) would return "$1,345.00"
=Dollar(A1+A2, 2) would return "$172.10"

Read More