Terms

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 41

Term

Grovel
Disciples
Vasectomies
Conundrum
Vicissitudes
Enunciated
Concocted

Damocles

Isthmus
Alabaster
Pedestal
Qualm
Consonance
Rectitude
Pestered
Unabashed
Obstinacy
Infraction
Irony
Posterity
Belie
Asinine
Incendiary
Insinuations
Innuendos
Raucous
Rut
Blemish
Eschew
Haulier
Soft Shoulder
Shoulder
Ensnared
Lackey
Cleaver
Colluded
Offal
Millennials
Plebiscite
Condominium

Swab

Paramour
Baby Boomer
Sojourn
Berserk
Gaffe
Déjà Vu
Netizens
Itinerary
Dissuade

Monocle

Consummate
Shanty
Prorogue
Melle
Seminal
Tawdry
Vexation
Slugfest
Incensed
Squandered
Fetter
Blue-collar
Menial
Netizen
Beating Retreat
Shroud
Chauffeur
Gravel
Gaslighting

Démarche

Accession
Haggling
Restive
Recidivists
Crevice
Synagogue
Prorogation

Furlough

Scion
Bailiff
Phubbing
Scourge
Tattered
Sanguine
Staunch
Resile
Aapostate
Razzmatazz
Celibate
Diurnality
Darning
Coroner
Oxymoronic
Father Account Number
Dogfooding
Nonchalant
Dandelion
Pencil Detritus
Wood Shavings
Smother
Meaning
lie or move abjectly on the ground with one's face downward.
a personal follower of Jesus during his life, especially one of the twelve Apostles.
the surgical cutting and sealing of part of each vas deferens, typically as a means of sterilization.
a confusing and difficult problem or question.
a change of circumstances or fortune, typically one that is unwelcome or unpleasant.
say or pronounce clearly.
make (a dish or meal) by combining various ingredients.
a legendary courtier who extravagantly praised the happiness of Dionysius I, ruler of Syracuse. To show him how precarious th
hair over his head.
a narrow strip of land with sea on either side, forming a link between two larger areas of land
a fine-grained, translucent form of gypsum, typically white, often carved into ornaments. (Sang-e-Mar-Mar)
the base or support on which a statue, obelisk, or column is mounted.
an uneasy feeling of doubt, worry, or fear, especially about one's own conduct; a misgiving.
agreement or compatibility between opinions or actions.
morally correct behavior or thinking; righteousness.
trouble or annoy (someone) with frequent or persistent requests or interruptions. (Satana)
not embarrassed, disconcerted, or ashamed. (Khuly)
the quality or condition of being obstinate; stubbornness. (Zid)
a violation or infringement of a law, agreement, or set of rules. (Khilaf Warzi)
the expression of one's meaning by using language that normally signifies the opposite, typically for humorous or emphatic eff
all future generations of people.
fail to give a true notion or impression of (something); disguise or contradict. (Jhuthlaty)
extremely stupid or foolish.
(of a device or attack) designed to cause fires.
an unpleasant hint or suggestion of something bad.
an allusive or oblique remark or hint, typically a suggestive or disparaging one.
making or constituting a disturbingly harsh and loud noise.
a long deep track made by the repeated passage of the wheels of vehicles
spoil the appearance of (something) that is otherwise aesthetically perfect.
deliberately avoid using; abstain from.
a person or company employed in the transport of goods or materials by road OR a miner who is responsible for transporting
an unpaved strip of land at the side of a road.
a paved strip alongside a road for stopping on in an emergency.
catch in or as in a trap.
a servant, especially a liveried footman or manservant.
a tool with a heavy broad blade, used by butchers for chopping meat.
come to a secret understanding for a harmful purpose; conspire.
the entrails and internal organs of an animal used as food.
a person reaching young adulthood around the year 2000; a Generation Yer.
the direct vote of all the members of an electorate on an important public question
a building or complex of buildings containing a number of individually owned apartments or houses.
an absorbent pad or piece of material used in surgery and medicine for cleaning wounds, applying medication, or taking specim
other surface.
a lover, especially the illicit partner of a married person.
a person born in the years following World War II, when there was a temporary marked increase in the birth rate.
stay somewhere temporarily.
(of a person or animal) out of control with anger or excitement; wild or frenzied.
an unintentional act or remark causing embarrassment to its originator; a blunder.
Already Seen
a user of the Internet, especially a habitual or avid one.
a planned route or journey.
persuade (someone) not to take a particular course of action.

is a type of corrective lens used to correct or enhance the vision in only one eye. It consists of a circular lens, generally with a w

make (a marriage or relationship) complete by having sexual intercourse.


A shack is a type of small, often primitive shelter or dwelling
discontinue a session of (a parliament or other legislative assembly) without dissolving it.
a confused fight or scuffle.
strongly influencing later developments.
showy but cheap and of poor quality.
the state of being annoyed, frustrated, or worried.
a tough and challenging contest, especially in sports such as boxing and baseball.
very angry; enraged.
waste (something, especially money or time) in a reckless and foolish manner.
a chain or manacle used to restrain a prisoner, typically placed around the ankles.
relating to manual work or workers, particularly in industry
(of work) not requiring much skill and lacking prestige.
a user of the Internet, especially a habitual or keen one.
Beating Retreat is a military ceremony dating to 16th century England and was first used to recall nearby patrolling units to the
a length of cloth or an enveloping garment in which a dead person is wrapped for burial.
a person employed to drive a private or rented automobile.
a loose aggregation of small water-worn or pounded stones
manipulate (someone) by psychological means into questioning their own sanity.
formal diplomatic representation (diplomatic correspondence) of the official position, views, or wishes on a given subject from
Governments may also use a démarche to protest or object to actions by a foreign government.
the formal acceptance of a treaty or agreement.
dispute or bargain persistently, especially over the cost of something.
(of a person) unable to keep still or silent and becoming increasingly difficult to control, especially because of impatience, diss
a convicted criminal who reoffends, especially repeatedly
a narrow opening or fissure, especially in a rock or wall.
the building where a Jewish assembly or congregation meets for religious worship and instruction
the action of discontinuing a session of a parliament or other legislative assembly without dissolving it.
A furlough (/ˈfɜːrloʊ/; from Dutch: verlof, "leave of absence") is a temporary leave of employees due to special needs of a com
employer or in society as a whole.
a descendant of a notable family.
a sheriff's officer who executes writs and processes and carries out distraints and arrests.
the practice of ignoring one's companion or companions in order to pay attention to one's phone or other mobile device.
a whip used as an instrument of punishment.
old and torn; in poor condition (tattered notes)
optimistic or positive, especially in an apparently bad or difficult situation
very loyal and committed in attitude.
abandon a position or a course of action.
a person who abandons his or her religion, party, cause, etc
noisy, showy, and exciting activity and display designed to attract and impress.
abstaining from marriage and sexual relations, typically for religious reasons.
Diurnality is a form of plant and animal behavior characterized by activity during daytime, with a period of sleeping or other in
Darning is a sewing technique for repairing holes or worn areas in fabric or knitting using needle and thread alone.
a public officer whose principal duty is to inquire by an inquest into the cause of death when there is reason to think the death
a combination of contradictory or incongruous words (such as cruel kindness) broadly : something (such as a concept) that is m
001-003847206-001-3
Tech speak for "internally beta testing pre-release software" so if a message like this was ever supposed to go out, it should ha
(of a person or manner) feeling or appearing casually calm and relaxed; not displaying anxiety, interest, or enthusiasm.
Taraxacum is a large genus of flowering plants in the family Asteraceae, which consists of species commonly known as dandeli
waste or debris of any kind.
of pencil
kill (someone) by covering their nose and mouth so that they suffocate.
Description
Duplicate
Special Char.
Extract After
Extract Before
MINUS YEARS
Count All Spaces
Delete line breaks and nonprinting characters
Carriage Return (value 13) and Line Feed
Line Break
REMOVE LAST , OR .
contain and not contain
After Last Comma
SECOND LAST
copy every 4th row
starts with ~
find nth occurance (i.e. D4 = 1, 2 , 3 or 4)
identify 1st, 2nd, 3rd, etc. occurrences
count extra spaces
Count Line Break
Extract Text After Multiple Line Breaks
Numbers from right
Numbers from left

Get number from any position in a string

Countifs column based criteria


Strip non-numeric characters (Array Formula)
Range contains one of many substrings
EXACT SEARCH
Replace Line Break
Accounting Number Format

Extract Text Between Two Words With Formula In Excel

Ranking with 1st, 2nd, 3rd


Assign Serial Number To Unique Value With Formula
Count cells between dates
Count Unique Values Within Date Range By Formula
INDEX MATCH – multiple results

Removing Non-Alphanumeric Characters

Value is between two numbers


convert a column of text URLs into active hyperlinks
Greek Text in Word
Convert Numbers Upto Billion into Words
Convert Numbers into Currency Upto Billion
Convert Numbers into Currency Upto Trillion
Value exists in a range
Extract Numbers from Right (Array Formula)
SEARCH MORE THAN ONE PHRASES
RETURN CELL REF. HAVING HIGHEST VALUE
Restart Numbering After Specific Row
Contains only ABC
Concatenate Multiple Rows until Non-Blank in Adjacent
Column
Restart Numbering When Value Changes in Other Cell
RETURN CHARACTER NUMBER
DATE FROM LEFT MID AND RIGHT
Find and replace multiple values
Find 5 Largest
Find 5 Smallest
Extract All Entries
Extract last two words from cell
Extract last N words from cell
Combine Date And Time Columns Into One Column
Formatting
Fill Blank Cells (Array Formula)
NACTA Duplicate Removal
split number into each individual digit in columns
Concatenate unique distinct values (Array Formula)
Remove Text After The Second Or Nth Specific Delimiter
(Space, Comma, Etc.) From Text Strings
Remove Text Before The Second Or Nth Specific Delimiter
(Space, Comma, Etc.) From Text Strings
Duplicate Count with Condition
Count specific character in Excel (K is Character)
Numbering Unique Values in Excel
First Day of Year
Last Day of Year
Sum Based on Year (two dashes befor year if not work)
COUNTIFS with array constant
Return the previous working or business day
Count Based on Length (Array)
Extract Text Before Last Space

CNIC C-Link
Formula
IF(COUNTIF($L$2:L2,L2)>1=FALSE,"No","Yes")
IFERROR(MIN(FIND(MID(L2,ROW(INDIRECT("1:"&LEN(L2))),1),$R$2)),0)=0 : ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmn
TRIM(MID(A2,SEARCH($D$2,A2)+LEN($D$2),255))
TRIM(LEFT(A2,SEARCH($D$2,A2)-1))
DATE(YEAR(A1)-3,MONTH(A1),DAY(A1))
LEN(A2)-LEN(SUBSTITUTE(A2," ",""))
TRIM(CLEAN(A2))
SUBSTITUTE(SUBSTITUTE(A2, CHAR(13)," "), CHAR(10), " ")
TRIM(SUBSTITUTE(A2, CHAR(160), " "))
IF(RIGHT(A2,1)=",",LEFT(A2,LEN(A2)-1),A2)
{AND(COUNT(SEARCH({"red","blue","green"},B5))>0,COUNT(SEARCH({"orange","pink"},B5))=0)}
TRIM(RIGHT(SUBSTITUTE(A1,",",REPT(" ",LEN(A1))),LEN(A1)))
TRIM(MID(L2, SEARCH("^",SUBSTITUTE(L2,"|","^", LEN(L2)-LEN(SUBSTITUTE(L2,"|",""))-1))+1,9999))
INDEX($A$2:$A$16,ROWS(C$2:C2)*5-5+COLUMNS($C2:C2))
IF(LEFT(TRIM(I2),1)=CHAR(126),"OK","Not OK")
FIND("~",SUBSTITUTE(B4,"x","~",D4)) : ~ character that does not exist in text
COUNTIF($A$2:$A2, $A2)
LEN(A2)-LEN(TRIM(A2))
LEN(B5)-LEN(SUBSTITUTE(B5,CHAR(10),""))+1
TRIM(MID(SUBSTITUTE($C5,CHAR(10),REPT(" ",LEN($C5))), (D$4-1)*LEN($C5)+1, LEN($C5))) - Column name to be given 1, 2,
RIGHT(A2,SUM(LEN(A2) - LEN(SUBSTITUTE(A2, {"0","1","2","3","4","5","6","7","8","9"},""))))
LEFT(A2,SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{"0","1","2","3","4","5","6","7","8","9"},""))))
SUMPRODUCT(MID(0&A2, LARGE(INDEX(ISNUMBER(--MID(A2, ROW(INDIRECT("1:"&LEN(A2))), 1)) * ROW(INDIRECT("1:"&LEN
10^ROW(INDIRECT("1:"&LEN(A2)))/10)
COUNTIFS(INDEX(Table1,0,MATCH(G5,Table1[#Headers],0)),"x")
TEXTJOIN("",TRUE,IFERROR(MID(B5,ROW(INDIRECT("1:100")),1)+0,""))
SUMPRODUCT(COUNTIF(rng,"*"&substrings&"*"))>0
ISNUMBER(SEARCH(" WEL "," "&B2&" "))
SUBSTITUTE(A1,CHAR(10),", ")
#,##0;[Red](#,##0);-?

MID(A1,SEARCH("KTE",A1)+3,SEARCH("feature",A1)-SEARCH("KTE",A1)-4)

RANK(A2,A$2:A$8)&MID("thstndrdth",MIN(9,2*RIGHT(RANK(A2,A$2:A$8))*(MOD(RANK(A2,A$2:A$8)-11,100)>2)+1),2)
IF(COUNTIF(A$2:A2,A2)=1,MAX(B$1:B1)+1,VLOOKUP(A2,A$1:B1,2,0))
COUNTIFS(range,">="&date1,range,"<="&date2)
SUMPRODUCT(IF((B2:B8<=E2)*(B2:B8>=E1), 1/COUNTIFS(B2:B8, "<="&E2, B2:B8, ">="&E1, A2:A8, A2:A8), 0))
INDEX($C$3:$C$8, SMALL(IF(ISNUMBER(MATCH($B$3:$B$8, $E$3, 0)), MATCH(ROW($B$3:$B$8), ROW($B$3:$B$8)), ""), ROW

UPPER(CLEAN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTI
(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTIT
SUBSTITUTE(SUBSTITUTE(A2,CHAR(32),""),CHAR(33),""),CHAR(34),""),CHAR(35),""),CHAR(36),""),CHAR(37),""),CHAR(38),""),CH
AR(45),""),CHAR(46),""),CHAR(47),""),CHAR(58),""),CHAR(59),""),CHAR(60),""),CHAR(61),""),CHAR(62),""),CHAR(63),""),CHAR(6
),""),CHAR(123),""),CHAR(124),""),CHAR(125),""),CHAR(126),"")))

AND(val>MIN(num1,num2),val<MAX(num1,num2))
=hyperlink("Description")
lorem(15,5)
IF(OR(LEN(FLOOR(B2,1))=13,FLOOR(B2,1)<=0),"Out of range",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B2
IF(OR(LEN(FLOOR(B2,1))=13,FLOOR(B2,1)<=0),"Out of range",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B2
IF(B5<=0,"Out of range",TRIM(PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),1,1)+1,"","one hu
COUNTIF(range,value)>0
RIGHT(A1,MATCH(FALSE,ISNUMBER(MID(A1,LEN(A1)+1-ROW(INDEX($A:$A,1):INDEX($A:$A,LEN(A1))),1)+0),0)-1)
SUMPRODUCT(--ISNUMBER(SEARCH(things,g2)))>0
ADDRESS(MATCH(MAX(I:I),I:I,0),1)
MOD(ROW()-2,518)+1
SUMPRODUCT(SEARCH(MID(C2,ROW(INDIRECT("1:"&LEN(C2))),1),"abcdefghijklmnopqrstuvwxyz"))

IF(A3<>"",B2,B2&C3)

COUNTIF(C$2:C2,C2)
IFERROR(TEXTJOIN(",", TRUE,CODE(MID(B3, ROW($A$1:INDEX($A$1:$A$1000, LEN(B3))), 1))), "EMPTY")
DATE(LEFT(text,4),MID(text,5,2),RIGHT(text,2))
SUBSTITUTE(SUBSTITUTE(B5,INDEX(find,1),INDEX(replace,1)),INDEX(find,2),INDEX(replace,2))
LARGE(A$2:A$16,ROWS(B$2:B2))
SMALL(A$2:A$16,ROWS(C$2:C2))
IFERROR(INDEX(names,SMALL(IF(groups=E$4,ROW(names)-MIN(ROW(names))+1),ROWS($E$5:E5))),"")
MID(A1,FIND("@",SUBSTITUTE(A1," ","@",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))-1))+1,100)
MID(B5,FIND("@",SUBSTITUTE(B5," ","@",LEN(B5)-LEN(SUBSTITUTE(B5," ",""))-(N-1)))+1,LEN(B5))
concatenate(text(A2,"mm/dd/yyyy")&" "&text(B2,"hh:mm:ss"))
#,##0_);[Red](#,##0);-?
IF(ISBLANK($A2),$AC1,$A2)
INDEX([sdf],MATCH(1,(AP2=[id])*($AU$3=[name4]),0))
MID($A2,COLUMN()-1,1)
TEXTJOIN(", ", TRUE, IF(MATCH(B3:B6, B3:B6, 0)=MATCH(ROW(B3:B6), ROW(B3:B6)), B3:B6, ""))

LEFT(SUBSTITUTE(A2," ","#",3),FIND("#",SUBSTITUTE(A2," ","#",2),1)-1)

RIGHT(cell,LEN(cell)-FIND("#",SUBSTITUTE(cell," ","#",N)))

SUM(IF([@[Branch Code]]=RH_BUSW1[Branch Code], 1/(COUNTIFS(RH_BUSW1[Branch Code], [@[Branch Code]], RH_BUSW1


LEN(B2)-LEN(SUBSTITUTE(B2,K2,""))
IF(COUNTIF(A$2:A2,A2)=1,MAX(B$1:B1)+1,VLOOKUP(A2,A$1:B1,2,0))

SUMPRODUCT((YEAR(date_range)=year)*sum_range)
SUM(COUNTIFS(A2:A10, {"apples","bananas","lemons"}, C2:C10, "delivered"))
WORKDAY(TODAY(),-1,F2:F4)
SUM(1*(LEN(G4:G999)=14))
LEFT(A1,SEARCH("^^",SUBSTITUTE(A1," ","^^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))-1)

IF(ISNUMBER(VALUE(LEFT(TRIM(LEFT(I2,SEARCH(",",I2)-1)),SEARCH("|",TRIM(LEFT(I2,SEARCH(",",I2)-1)))-1)))=TRUE,"Yes",IF(IS
LEN(SUBSTITUTE(I2,"|",""))-1))+1,9999)),SEARCH("|",TRIM(MID(I2, SEARCH("^",SUBSTITUTE(I2,"|","^", LEN(I2)-LEN(SUBSTITU
IF(ISNUMBER(VALUE(LEFT(TRIM(LEFT(D2,SEARCH(",",D2)-1)),SEARCH("|",TRIM(LEFT(D2,SEARCH(",",D2)-1)))-1)))=TRUE,"Yes",I
LEN(D2)-LEN(SUBSTITUTE(D2,"|",""))-1))+1,9999)),SEARCH("|",TRIM(MID(D2, SEARCH("^",SUBSTITUTE(D2,"|","^", LEN(D2)-LE
,"four hundred ","five hundred ","six hundred ","seven hundred ","eight hundred ","nine hundred "),CHOOSE(MID(TEXT(INT(B2),REPT(0,1
,"four hundred ","five hundred ","six hundred ","seven hundred ","eight hundred ","nine hundred "),CHOOSE(MID(TEXT(INT(B2),REPT(0,1
","six hundred ","seven hundred ","eight hundred ","nine hundred "),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),2,1)+1,"",CHOOSE(MID(TEXT
D(TEXT(INT(B2),REPT(0,12)),2,1)+1,"",CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),3,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen
D(TEXT(INT(B2),REPT(0,12)),2,1)+1,"",CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),3,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen
+1,"",CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),3,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighte
een","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"
een","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"
en","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(B5),R
venty","eighty","ninety"),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),3,1)+1,"","-one","-two"
venty","eighty","ninety"),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),3,1)+1,"","-one","-two"
LUE(MID(TEXT(INT(B5),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),3,1)+1,"","-one","-two","-three","-four","-five","-six","
,3,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),2,1))=0,CHOOSE(M
,3,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),2,1))=0,CHOOSE(M
e","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),3
0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),3,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(B2>=
0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),3,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(B2>=
XT(INT(B5),REPT(0,12)),3,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(B5>=10^9," billion ",""),CHOOSE(M
ight","nine"),"")),IF(B2>=10^9," billion ",""),CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),4,1)+1,"","one hundred ","two hundred ","three hundr
ight","nine"),"")),IF(B2>=10^9," billion ",""),CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),4,1)+1,"","one hundred ","two hundred ","three hundr
billion ",""),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),4,1)+1,"","one hundred ","two hundred ","three hundred ","four hundred ","five hun
hundred ","three hundred ","four hundred ","five hundred ","six hundred ","seven hundred ","eight hundred ","nine hundred "),CHOOSE
hundred ","three hundred ","four hundred ","five hundred ","six hundred ","seven hundred ","eight hundred ","nine hundred "),CHOOSE
our hundred ","five hundred ","six hundred ","seven hundred ","eight hundred ","nine hundred "),CHOOSE(MID(TEXT(INT(B5),REPT(0,12))
ine hundred "),CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),5,1)+1,"",CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),6,1)+1,"ten","eleven","twelve","t
ine hundred "),CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),5,1)+1,"",CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),6,1)+1,"ten","eleven","twelve","t
EXT(INT(B5),REPT(0,12)),5,1)+1,"",CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),6,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","
en","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty"
en","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty"
n","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF
rty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B2),REPT(0,
rty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B2),REPT(0,
nty","eighty","ninety"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),6,1)+1,"","-one","-two","-t
ID(TEXT(INT(B2),REPT(0,12)),6,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(B2),R
ID(TEXT(INT(B2),REPT(0,12)),6,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(B2),R
1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),5,1))=0,CHOOSE(MID
LUE(MID(TEXT(INT(B2),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),6,1)+1,"","one","two","three","four","five","six","seven
LUE(MID(TEXT(INT(B2),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),6,1)+1,"","one","two","three","four","five","six","seven
12)),5,1))=0,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),6,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(
four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),4,3))>0," million ",""),CHOOSE(MID(TEXT(INT(B2),RE
four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),4,3))>0," million ",""),CHOOSE(MID(TEXT(INT(B2),RE
t","nine"),"")),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),4,3))>0," million ",""),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),7,1)+1,"","one hundr
SE(MID(TEXT(INT(B2),REPT(0,12)),7,1)+1,"","one hundred ","two hundred ","three hundred ","four hundred ","five hundred ","six hundred
SE(MID(TEXT(INT(B2),REPT(0,12)),7,1)+1,"","one hundred ","two hundred ","three hundred ","four hundred ","five hundred ","six hundred
2)),7,1)+1,"","one hundred ","two hundred ","three hundred ","four hundred ","five hundred ","six hundred ","seven hundred ","eight hun
e hundred ","six hundred ","seven hundred ","eight hundred ","nine hundred "),CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),8,1)+1,"",CHOOSE
e hundred ","six hundred ","seven hundred ","eight hundred ","nine hundred "),CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),8,1)+1,"",CHOOSE
en hundred ","eight hundred ","nine hundred "),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),8,1)+1,"",CHOOSE(MID(TEXT(INT(B5),REPT(0,12))
0,12)),8,1)+1,"",CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),9,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventee
0,12)),8,1)+1,"",CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),9,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventee
EXT(INT(B5),REPT(0,12)),9,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twe
en","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT
en","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT
hteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),8,1))>1,CH
ty"),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),9,1)+1,"","-one","-two","-three","-four","-five
ty"),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),9,1)+1,"","-one","-two","-three","-four","-five
5),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),9,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nin
o","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B2),REP
o","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B2),REP
","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),9,1)+1,"","one","two"
E(MID(TEXT(INT(B2),REPT(0,12)),9,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(INT(B2)
E(MID(TEXT(INT(B2),REPT(0,12)),9,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(INT(B2)
)),9,1)+1,"","one","two","three","four","five","six","seven","eight","nine"),"")),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),7,3))," thousand ",
ALUE(MID(TEXT(INT(B2),REPT(0,12)),7,3))," thousand ",""),CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),10,1)+1,"","one hundred ","two hundre
ALUE(MID(TEXT(INT(B2),REPT(0,12)),7,3))," thousand ",""),CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),10,1)+1,"","one hundred ","two hundre
0,12)),7,3))," thousand ",""),CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),10,1)+1,"","one hundred ","two hundred ","three hundred ","four hun
hundred ","two hundred ","three hundred ","four hundred ","five hundred ","six hundred ","seven hundred ","eight hundred ","nine hun
hundred ","two hundred ","three hundred ","four hundred ","five hundred ","six hundred ","seven hundred ","eight hundred ","nine hun
ree hundred ","four hundred ","five hundred ","six hundred ","seven hundred ","eight hundred ","nine hundred "),CHOOSE(MID(TEXT(INT
ght hundred ","nine hundred "),CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),11,1)+1,"",CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),12,1)+1,"ten","
ght hundred ","nine hundred "),CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),11,1)+1,"",CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),12,1)+1,"ten","
,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),11,1)+1,"",CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),12,1)+1,"ten","eleven","twelve","thirteen","fo
T(0,12)),12,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","
T(0,12)),12,1)+1,"ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","
","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"),"twenty","thirty","forty","fifty","sixty","seventy","
en"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),11,1))>1,CHOOSE(MID(T
en"),"twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),11,1))>1,CHOOSE(MID(T
fifty","sixty","seventy","eighty","ninety"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),12,1)+
11,1))>1,CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),12,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE
11,1))>1,CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),12,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE
T(B5),REPT(0,12)),12,1)+1,"","-one","-two","-three","-four","-five","-six","-seven","-eight","-nine"),IF(VALUE(MID(TEXT(INT(B5),REPT(0,12)
eight","-nine"),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),12,1)+1,"","one","two","three","
eight","-nine"),IF(VALUE(MID(TEXT(INT(B2),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B2),REPT(0,12)),12,1)+1,"","one","two","three","
TEXT(INT(B5),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(B5),REPT(0,12)),12,1)+1,"","one","two","three","four","five","six","seven","eigh
"","one","two","three","four","five","six","seven","eight","nine"),"")))," "," ")))
"","one","two","three","four","five","six","seven","eight","nine"),"")))," "," ")&IF(FLOOR(B2,1)>1," dollars"," dollar"))&IF(ISERROR(FIND("."
five","six","seven","eight","nine"),"")))," "," ")&IF(FLOOR(B5,1)>1," dollars"," ")&IF(AND(B5>=1,B5<2),"dollar",""))&IFERROR(IF(B5<1,SUBS

You might also like