Description
Microsoft Excel Formulas
Function J Syntax Wbat Does it Do ? Function J Syntax Wbat Does it Do ?
Batabase Besciiption
Boto voliJotion Matbematical Description
BAvERAuE Retuins the aveiage of selecteu uatabase entiies 6CB Retuins the gieatest common uivisoi
BC00NT Counts the cells that contain numbeis in a uatabase lCH Retuins the least common multiple
BC00NTA Counts nonblank cells in a uatabase HR00NB Retuins a numbei iounueu to the uesiieu multiple
BuET
Extiacts fioma uatabase a single iecoiu that matches the specifieu
ciiteiia
µ00TlFNT Retuins the integei poition of a uivision
BNAX Retuins the maximumvalue fiomselecteu uatabase entiies ABS Retuins the absolute value of a numbei
BNIN Retuins the minimumvalue fiomselecteu uatabase entiies CEILINu
Rounus a numbei to the neaiest integei oi to the neaiest multiple of
significance
BS0N
Auus the numbeis in the fielu column of iecoius in the uatabase that
match the ciiteiia
C0NBIN Retuins the numbei of combinations foi a given numbei of objects
Date Description C00NTIF
Counts the numbei of nonblank cells within a iange that meet the given
ciiteiia
Boy, WeekJoy, ToJoy Text function EvEN Rounus a numbei up to the neaiest even integei
Bote, Hontb & Yeor Text function FACT Retuins the factoiial of a numbei
YEARFRAC
Retuins the yeai fiaction iepiesenting the numbei of whole uays
between stait_uate anu enu_uate
FL00R Rounus a numbei uown, towaiu zeio; R00NBB0WN
BATE INT Rounus a numbei uown to the neaiest integei
BATFBlI Calculates the uiffeience between two uates. N0B Retuins the iemainuei fiomuivision
BAY Conveits a seiial numbei to a uay of the month 0BB Rounus a numbei up to the neaiest ouu integei
B00R Conveits a seiial numbei to an houi PI Retuins the value of Pi
HlN0TF Conveits a seiial numbei to a minute P0WER Retuins the iesult of a numbei iaiseu to a powei
N0NTB Conveits a seiial numbei to a month PR0B0CT Nultiplies its aiguments; *
N0W Retuins the seiial numbei of the cuiient uate anu time R0NAN Conveits an aiabic numeial to ioman, as text
SEC0NB Conveits a seiial numbei to a seconu R00NB Rounus a numbei to a specifieu numbei of uigits
TINE Retuins the seiial numbei of a paiticulai time R00NBB0WN Rounus a numbei uown, towaiu zeio
TINEvAL0E Conveits a time in the foimof text to a seiial numbei R00NB0P Rounus a numbei up, away fiomzeio
T0BAY Retuins the seiial numbei of touay's uate S0BT0TAL Retuins a subtotal in a list oi uatabase
WEEKBAY Conveits a seiial numbei to a uay of the week S0N Auus its aiguments
YEAR Conveits a seiial numbei to a yeai S0NIF Auus the cells specifieu by a given ciiteiia
Age Calculation 0sing BATEBIF() Statistical Description
Engineering Description 6ropbs onJ Cborts Bisplays by F11
BIN2BEC Conveits a binaiy numbei to uecimal Pivot Toble Analysing table & giaph
C0NvFRT Conveits a numbei fiomone measuiement systemto anothei AvERAuE Retuins the aveiage of its aiguments
BEC2BIN Conveits a uecimal numbei to binaiy C0RREL Retuins the coiielation coefficient between two uata sets
BELTA Tests whethei two values aie equal C00NT Counts how many numbeis aie in the list of aiguments
Financial Description C00NTA Counts how many values aie in the list of aiguments
BB
Retuins the uepieciation of an asset foi a specifieu peiiou using the
fixeu-ueclining balance methou
F0RECAST Retuins a value along a lineai tienu
SLN Retuins the stiaight-line uepieciation of an asset foi one peiiou FREQ0ENCY Retuins a fiequency uistiibution as a veitical aiiay
SYB
Retuins the sum-of-yeais' uigits uepieciation of an asset foi a
specifieu peiiou
NAX Retuins the maximumvalue in a list of aiguments
Information Description NEBIAN Retuins the meuian of the given numbeis
ISEvEN Retuins TR0E if the numbei is even NIN Retuins the minimumvalue in a list of aiguments
IS0BB Retuins TR0E if the numbei is ouu N0BE Retuins the most common value in a uata set
CELL
Retuins infoimation about the foimatting, location, oi contents of a
cell
PERN0T Retuins the numbei of peimutations foi a given numbei of objects
C00NTBLANK Counts the numbei of blank cells within a iange Q0ARTILE Retuins the quaitile of a uata set
INF0 Retuins infoimation about the cuiient opeiating enviionment RANK Retuins the iank of a numbei in a list of numbeis
ISBLANK Retuins TR0E if the value is blank STBEv Estimates stanuaiu ueviation baseu on a sample
ISERR Retuins TR0E if the value is any eiioi value except #N¡A vAR Estimates vaiiance baseu on a sample
ISERR0R Retuins TR0E if the value is any eiioi value Text Description
ISL0uICAL Retuins TR0E if the value is a logical value Sentence to Cell Text to column
ISNA Retuins TR0E if the value is the #N¡A eiioi value Iormottinq Cell value
ISN0NTEXT Retuins TR0E if the value is not text ConJitionol Iormottinq Cell value as pei iules
ISN0NBER Retuins TR0E if the value is a numbei CBAR Retuins the chaiactei specifieu by the coue numbei
ISREF Retuins TR0E if the value is a iefeience CLEAN Removes all nonpiintable chaiacteis fiomtext
ISTEXT Retuins TR0E if the value is text C0BE Retuins a numeiic coue foi the fiist chaiactei in a text stiing
N Retuins a value conveiteu to a numbei C0NCATENATE }oins seveial text items into one text item
NA Retuins the eiioi value #N¡A EXACT Checks to see if two text values aie iuentical
TYPE Retuins a numbei inuicating the uata type of a value LEFT Retuins the leftmost chaiacteis fioma text value
Logical Description LEN Retuins the numbei of chaiacteis in a text stiing
ANB Retuins TR0E if all its aiguments aie TR0E L0WER Conveits text to loweicase
IF Specifies a logical test to peifoim NIB
Retuins a specific numbei of chaiacteis fioma text stiing staiting at the
position you specify
N0T Reveises the logic of its aigument PR0PER Capitalises the fiist lettei in each woiu of a text value
0R Retuins TR0E if any aigument is TR0E REPLACE Replaces chaiacteis within text
Lookup Description REPT Repeats text a given numbei of times
IS RIuBT Retuins the iightmost chaiacteis fioma text value
I4 TEXT
BL00K0P
Looks in the top iow of an aiiay anu ietuins the value of the
inuicateu cell
TRIN Removes spaces fiomtext
INBEX 0ses an inuex to choose a value fioma iefeience oi aiiay 0PPER Conveits text to uppeicase
NATCB Looks up values in a iefeience oi aiiay vBA for Spell Number Retuins to Chaiacteis fiomNumbeis
TRANSP0SE Retuins the tianspose of an aiiay
vL00K0P
Looks in the fiist column of an aiiay anu moves acioss the iow to
ietuin the value of a cell
F ÆiC RmFPH WCL FMCD EFCFPFPCF
AÒVANÛ¡Ò M5 ¡AÛ¡L TKAÍNÍNÛ
7oo|Lec¬ C|o±o| H¬µi¬ee-i¬µ, Hu|, BeLo-|, Ciµo±µoce, Vimo¬ Hoµo-, Po¬e-|H
UUU.TCCLTGCm.PGT
doc_968477734.pdf
Microsoft Excel Formulas
Function J Syntax Wbat Does it Do ? Function J Syntax Wbat Does it Do ?
Batabase Besciiption
Boto voliJotion Matbematical Description
BAvERAuE Retuins the aveiage of selecteu uatabase entiies 6CB Retuins the gieatest common uivisoi
BC00NT Counts the cells that contain numbeis in a uatabase lCH Retuins the least common multiple
BC00NTA Counts nonblank cells in a uatabase HR00NB Retuins a numbei iounueu to the uesiieu multiple
BuET
Extiacts fioma uatabase a single iecoiu that matches the specifieu
ciiteiia
µ00TlFNT Retuins the integei poition of a uivision
BNAX Retuins the maximumvalue fiomselecteu uatabase entiies ABS Retuins the absolute value of a numbei
BNIN Retuins the minimumvalue fiomselecteu uatabase entiies CEILINu
Rounus a numbei to the neaiest integei oi to the neaiest multiple of
significance
BS0N
Auus the numbeis in the fielu column of iecoius in the uatabase that
match the ciiteiia
C0NBIN Retuins the numbei of combinations foi a given numbei of objects
Date Description C00NTIF
Counts the numbei of nonblank cells within a iange that meet the given
ciiteiia
Boy, WeekJoy, ToJoy Text function EvEN Rounus a numbei up to the neaiest even integei
Bote, Hontb & Yeor Text function FACT Retuins the factoiial of a numbei
YEARFRAC
Retuins the yeai fiaction iepiesenting the numbei of whole uays
between stait_uate anu enu_uate
FL00R Rounus a numbei uown, towaiu zeio; R00NBB0WN
BATE INT Rounus a numbei uown to the neaiest integei
BATFBlI Calculates the uiffeience between two uates. N0B Retuins the iemainuei fiomuivision
BAY Conveits a seiial numbei to a uay of the month 0BB Rounus a numbei up to the neaiest ouu integei
B00R Conveits a seiial numbei to an houi PI Retuins the value of Pi
HlN0TF Conveits a seiial numbei to a minute P0WER Retuins the iesult of a numbei iaiseu to a powei
N0NTB Conveits a seiial numbei to a month PR0B0CT Nultiplies its aiguments; *
N0W Retuins the seiial numbei of the cuiient uate anu time R0NAN Conveits an aiabic numeial to ioman, as text
SEC0NB Conveits a seiial numbei to a seconu R00NB Rounus a numbei to a specifieu numbei of uigits
TINE Retuins the seiial numbei of a paiticulai time R00NBB0WN Rounus a numbei uown, towaiu zeio
TINEvAL0E Conveits a time in the foimof text to a seiial numbei R00NB0P Rounus a numbei up, away fiomzeio
T0BAY Retuins the seiial numbei of touay's uate S0BT0TAL Retuins a subtotal in a list oi uatabase
WEEKBAY Conveits a seiial numbei to a uay of the week S0N Auus its aiguments
YEAR Conveits a seiial numbei to a yeai S0NIF Auus the cells specifieu by a given ciiteiia
Age Calculation 0sing BATEBIF() Statistical Description
Engineering Description 6ropbs onJ Cborts Bisplays by F11
BIN2BEC Conveits a binaiy numbei to uecimal Pivot Toble Analysing table & giaph
C0NvFRT Conveits a numbei fiomone measuiement systemto anothei AvERAuE Retuins the aveiage of its aiguments
BEC2BIN Conveits a uecimal numbei to binaiy C0RREL Retuins the coiielation coefficient between two uata sets
BELTA Tests whethei two values aie equal C00NT Counts how many numbeis aie in the list of aiguments
Financial Description C00NTA Counts how many values aie in the list of aiguments
BB
Retuins the uepieciation of an asset foi a specifieu peiiou using the
fixeu-ueclining balance methou
F0RECAST Retuins a value along a lineai tienu
SLN Retuins the stiaight-line uepieciation of an asset foi one peiiou FREQ0ENCY Retuins a fiequency uistiibution as a veitical aiiay
SYB
Retuins the sum-of-yeais' uigits uepieciation of an asset foi a
specifieu peiiou
NAX Retuins the maximumvalue in a list of aiguments
Information Description NEBIAN Retuins the meuian of the given numbeis
ISEvEN Retuins TR0E if the numbei is even NIN Retuins the minimumvalue in a list of aiguments
IS0BB Retuins TR0E if the numbei is ouu N0BE Retuins the most common value in a uata set
CELL
Retuins infoimation about the foimatting, location, oi contents of a
cell
PERN0T Retuins the numbei of peimutations foi a given numbei of objects
C00NTBLANK Counts the numbei of blank cells within a iange Q0ARTILE Retuins the quaitile of a uata set
INF0 Retuins infoimation about the cuiient opeiating enviionment RANK Retuins the iank of a numbei in a list of numbeis
ISBLANK Retuins TR0E if the value is blank STBEv Estimates stanuaiu ueviation baseu on a sample
ISERR Retuins TR0E if the value is any eiioi value except #N¡A vAR Estimates vaiiance baseu on a sample
ISERR0R Retuins TR0E if the value is any eiioi value Text Description
ISL0uICAL Retuins TR0E if the value is a logical value Sentence to Cell Text to column
ISNA Retuins TR0E if the value is the #N¡A eiioi value Iormottinq Cell value
ISN0NTEXT Retuins TR0E if the value is not text ConJitionol Iormottinq Cell value as pei iules
ISN0NBER Retuins TR0E if the value is a numbei CBAR Retuins the chaiactei specifieu by the coue numbei
ISREF Retuins TR0E if the value is a iefeience CLEAN Removes all nonpiintable chaiacteis fiomtext
ISTEXT Retuins TR0E if the value is text C0BE Retuins a numeiic coue foi the fiist chaiactei in a text stiing
N Retuins a value conveiteu to a numbei C0NCATENATE }oins seveial text items into one text item
NA Retuins the eiioi value #N¡A EXACT Checks to see if two text values aie iuentical
TYPE Retuins a numbei inuicating the uata type of a value LEFT Retuins the leftmost chaiacteis fioma text value
Logical Description LEN Retuins the numbei of chaiacteis in a text stiing
ANB Retuins TR0E if all its aiguments aie TR0E L0WER Conveits text to loweicase
IF Specifies a logical test to peifoim NIB
Retuins a specific numbei of chaiacteis fioma text stiing staiting at the
position you specify
N0T Reveises the logic of its aigument PR0PER Capitalises the fiist lettei in each woiu of a text value
0R Retuins TR0E if any aigument is TR0E REPLACE Replaces chaiacteis within text
Lookup Description REPT Repeats text a given numbei of times
IS RIuBT Retuins the iightmost chaiacteis fioma text value
I4 TEXT
BL00K0P
Looks in the top iow of an aiiay anu ietuins the value of the
inuicateu cell
TRIN Removes spaces fiomtext
INBEX 0ses an inuex to choose a value fioma iefeience oi aiiay 0PPER Conveits text to uppeicase
NATCB Looks up values in a iefeience oi aiiay vBA for Spell Number Retuins to Chaiacteis fiomNumbeis
TRANSP0SE Retuins the tianspose of an aiiay
vL00K0P
Looks in the fiist column of an aiiay anu moves acioss the iow to
ietuin the value of a cell
F ÆiC RmFPH WCL FMCD EFCFPFPCF
AÒVANÛ¡Ò M5 ¡AÛ¡L TKAÍNÍNÛ
7oo|Lec¬ C|o±o| H¬µi¬ee-i¬µ, Hu|, BeLo-|, Ciµo±µoce, Vimo¬ Hoµo-, Po¬e-|H
UUU.TCCLTGCm.PGT
doc_968477734.pdf