Text Functions - 'D' to 'F'

DOLLAR - returns currency format of a number
-----------------------------------------------------------------
Ex. =DOLLAR("10.625",2) returns 10.63
     =DOLLAR("10.624",2) returns 10.62
     =DOLLAR("10.625") returns 10.63
Note: second argument is 2 by default if not given


EXACT - matches two strings and returns true/false. it is case sensitive
-----------------------------------------------------------------
Ex. =EXACT("hello","hello") returns true
     =EXACT("hello","Hello") returns false


FIND - returns the position (>=1) of a string in another string
-----------------------------------------------------------------
Ex. =FIND("is","it is the fish season") returns 4
     =FIND("is","it is the fish season",5) returns 12
Note: 3 argument is the position from where it will start checking


trick to find second instance of a string


FIXED - Rounds a number to specified number of digits

-----------------------------------------------------------------

VALUE	Formula	Result	Description
1234	=FIXED(A2, 1)	1,234.0	Rounds the number in A2 one digit to the right of the decimal point.
1234	=FIXED(A3, -1)	1,230	Rounds the number in A3 one digit to the left of the decimal point.
1234	=FIXED(A4, -1,TRUE)	1230	Rounds the number in A4 one digit to the left of the decimal point, without commas (the TRUE argument).
1234	=FIXED(A5)	1,234.00	Rounds the number in A5 two digits to the left of the decimal point.