| Formulas:
All, Business/Financial,
Conversion, Date,
Standard
Functions: All, Business/Financial,
Conversion, Date,
Formatter, Standard,
Statistical, Trig
Global Parameters: All
All
Formulas (alphabetically) [Top]
| Formula |
Purpose |
| Amort() |
Amortization Schedule |
| Breakeven() |
Breakeven Analysis |
| CelsiusTo() |
Celsius to Fahrenheit
conversion |
| CompoundInterest()
|
Compound Interest |
| DateAdd()
|
Add # of days to
specified date |
| DayOfWeek() |
Day of week for
specified date |
| DaysBetween() |
# of days between
specified dates |
| DaysTo() |
Convert days to
years, hours, minutes and seconds |
| DaysUntil() |
# of days until
specified date |
| Effect() |
Effective annual
interest rate, given nominal rate and # of compounding periods/year |
| FahrTo() |
Fahrenheit to Celsius
conversion |
| FootMeter() |
Foot/Meter Conversion |
| HomeCurrency() |
Convert other
currency to home currency.
Set ExchgRateToHome
global parameter to specify exchange rate to use. |
| HoursTo() |
Convert hours to
years, days, minutes and seconds |
| InchCM() |
Inch/Centimeter
Conversion |
| Inv() |
Inverse of x |
| LoanAMT() |
Loan amount |
| LoanPMT() |
Loan payment per
month |
| LoanRate() |
Loan interest rate
per year |
| Markup() |
Cost-Sell-Markup |
| MileKM() |
Mile/Kilometer Conversion |
| MinsTo() |
Convert minutes
to year, days, hours and seconds |
| MortgageAMT() |
Mortgage amount |
| MortgagePMT() |
Mortgage payment
per month |
| MortgageRate() |
Mortgage interest
rate per year |
| Nominal() |
Nominal annual interest
rate, given effective rate and # of compounding periods/year |
| OtherCurrency()
|
Convert home
currency to other currency.
Set ExchgRateToOther
global parameter to specify exchange rate to use. |
| PercentChange()
|
Percent Change In
Values |
| PoundKG() |
Pound/Kilogram Conversion |
| Pow() |
Raise base to power |
| ProfitMargin() |
Profit Margin |
| Root() |
Integer root of
num |
| SecsTo() |
Convert seconds
to years, days, hours and minutes |
| Tip() |
Compute tip for
good service.
Computes tip amount,
total including tax and total excluding tax (useful if item
you are giving a tip for is not taxable).
Set TipPercent
global parameter to specify tip percentage to use.
Set TaxPercent
global parameter to specify tax rate percentage to use. |
| Tip2() |
Compute tip for
good service (prompt for tip percentage to use).
Computes tip amount,
total including tax and total excluding tax (useful if item
you are giving a tip for is not taxable).
Set TaxPercent
global parameter to specify tax rate percentage to use |
| Tip3() |
Compute tip for
good service (prompt for tax & tip percentages to use).
Computes tip amount,
total including tax and total excluding tax (useful if item
you are giving a tip for is not taxable). |
| TodayAdd() |
Add # of days to
today's date |
| Tvm() |
Time Value of Money |
| UKGallonLiter()
|
UK Gallon/Liter
Conversion |
| USGallonLiter()
|
US Gallon/Liter
Conversion |
| YardMeter() |
Yard/Meter Conversion |
| YearsTo() |
Convert years to
days, hours, minutes and seconds |
Business/Financial
Formulas [Top]
| Business/Financial
Formulas |
Purpose |
| Breakeven() |
Breakeven Analysis |
| CompoundInterest()
|
Compound Interest |
| Effect() |
Effective annual
interest rate, given nominal rate and # of compounding periods/year |
| HomeCurrency() |
Convert other
currency to home currency.
Set ExchgRateToHome
global parameter to specify exchange rate to use. |
| LoanAMT() |
Loan amount |
| LoanPMT() |
Loan payment per
month |
| LoanRate() |
Loan interest rate
per year |
| Markup() |
Cost-Sell-Markup |
| MortgageAMT() |
Mortgage amount |
| MortgagePMT() |
Mortgage payment
per month |
| MortgateRate() |
Mortgage interest
rate per year |
| Nominal() |
Nominal annual interest
rate, given effective rate and # of compounding periods/year |
| OtherCurrency()
|
Convert home
currency to other currency.
Set ExchgRateToOther
global parameter to specify exchange rate to use. |
| PercentChange()
|
Percent Change In
Values |
| ProfitMargin() |
Profit Margin |
| Tip() |
Compute tip for
good service.
Computes tip amount,
total including tax and total excluding tax (useful if item
you are giving a tip for is not taxable).
Set TipPercent
global parameter to specify tip percentage to use.
Set TaxPercent
global parameter to specify tax rate percentage to use. |
| Tip2() |
Compute tip for
good service (prompt for tip percentage to use).
Computes tip amount,
total including tax and total excluding tax (useful if item
you are giving a tip for is not taxable).
Set TaxPercent
global parameter to specify tax rate percentage to use. |
| Tip3() |
Compute tip for
good service (prompt for tax & tip percentages to use)
Computes tip amount,
total including tax and total excluding tax (useful if item
you are giving a tip for is not taxable). |
| Tvm() |
Time Value of Money |
Conversion
Formulas [Top]
| Conversion
Formulas |
Purpose |
| CelsiusTo() |
Celsius to Fahrenheit
conversion |
| FahrTo() |
Fahrenheit to Celsius
conversion |
| FootMeter() |
Foot/Meter Conversion |
| HomeCurrency() |
Convert other currency
to home currency |
| InchCM() |
Inch/Centimeter
Conversion |
| MileKM() |
Mile/Kilometer Conversion |
| OtherCurrency()
|
Convert home currency
to other currency |
| PoundKG() |
Pound/Kilogram Conversion |
| UKGallonLiter()
|
UK Gallon/Liter
Conversion |
| USGallonLiter()
|
US Gallon/Liter
Conversion |
| YardMeter() |
Yard/Meter Conversion |
Date
Formulas [Top]
| Date
Formulas |
Purpose |
| DateAdd() |
Add # of days to
specified date |
| DayOfWeek() |
Day of week for
specified date |
| DaysBetween() |
# of days between
specified dates |
| DaysTo() |
Convert days to
years, hours, minutes and seconds |
| DaysUntil() |
# of days until
specified date |
| HoursTo() |
Convert hours to
years, days, minutes and seconds |
| MinsTo() |
Convert minutes
to year, days, hours and seconds |
| SecsTo() |
Convert seconds
to years, days, hours and minutes |
| TodayAdd() |
Add # of days to
today's date |
| YearsTo() |
Convert years to
days, hours, minutes and seconds |
Standard
Formulas [Top]
| Standard
Formulas |
Purpose |
| Inv() |
Inverse of x |
| Pow() |
Raise base to power |
| Root() |
Integer root of
num |
All
Functions (alphabetically) [Top]
| Function |
Purpose |
| Abs(num) |
Absolute value of
number |
| Acos(num) |
Inverse cosine of
num; result in degrees |
| Acosh(num) |
Inverse hyperbolic
cosine of num; result in degrees |
| Acot(num) |
Inverse cotangent
of num; result in degrees |
| Acoth(num) |
Inverse hyperbolic
cotangent of num; result in degrees |
| Acsc(num) |
Inverse cosecant
of num; result in degrees |
| Acsch(num) |
Inverse hyperbolic
cosecant of num; result in degrees |
| Asec(num) |
Inverse secant of
num; result in degrees |
| Asech(num) |
Inverse hyperbolic
secant of num; result in degrees |
| Asin(num) |
Inverse sine of
num; result in degrees |
| Asinh(num) |
Inverse hyperbolic
sine of num; result in degrees |
| Atan(num) |
Inverse tangent
of num; result in degrees |
| Atanh(num) |
Inverse hyperbolic
tangent of num; result in degrees |
| Avg(num, …) |
Average of numbers |
| Breakeven?(fixedCost?,
variableCost?, unitPrice?, profit?, quantity?) |
Perform breakeven
analysis |
| C(n, r) |
# of ways of picking
r unordered outcomes from n possibilities (no repetition) |
| Cos(degrees) |
Cosine of angle
in degrees |
| Cosh(degrees) |
Hyperbolic cosine
of angle in degrees |
| Cot(degrees) |
Cotangent of angle
in degrees |
| Coth(degrees) |
Hyperbolic cotangent
of angle in degrees |
| Csc(degrees) |
Cosecant of angle
in degrees |
| Csch(degrees) |
Hyperbolic cosecant
of angle in degrees |
| DateAdd(month, day,
year, days) |
Add # of days to
specified date (e.g. DateAdd(1, 15, 2010, 100)) |
| DayHour?(days?,
hours?) |
Convert between
days and hours |
| DayMin?(days?, mins?)
|
Convert between
days and minutes |
| DaySec?(days?, secs?) |
Convert between
days and seconds |
| DaysBetween(month1,
day1, year1, month2, day2, year2) |
# of days between
specified dates |
| DaysUntil(month,
day, year) |
# of days until
specified date (e.g. DaysUntil(1, 15, 2010)) |
| Decimals(number,
digitsAfterPoint) |
Specify # of digits
to display after decimal point |
| Degrees(radians) |
Convert angle in
radians to degrees |
| Div(div1, div2)
|
Divide div1 by div2 |
| E(exp) |
Natural antilogarithm
(e to power 'exp') |
| FahrCelsius?(fahr?,
Celsius?) |
Convert between
Fahrenheit and Celsius degrees |
| FootMeter?(feet?,
meters?) |
Convert between
feet and meters |
| HourMin?(hours?,
mins?) |
Convert between
hours and minutes |
| HourSec?(hours?,
secs?) |
Convert between
hours and seconds |
| InchCM?(inches?,
centimeters?) |
Convert between
inches and centimeters |
| Interest?(nominal%?,
effect%?, periods) |
Convert between
nominal and effective annual interest rate for # of compounding
periods/year |
| Inv(x) |
Inverse of x (1/x) |
| Ln(num) |
Natural logarithm
of num |
| Log(num) |
Base 10 logarithm
of num |
| Log2(num) |
Base 2 logarithm
of num |
| Median(num, …) |
Median of numbers |
| MileKM?(miles?,
kilometers?) |
Convert between
miles and kilometers |
| MinSec?(mins?, secs?) |
Convert between
minutes and seconds |
| Mod(num, modulus) |
Modulus mod of
num.
= num - modulus*INT(num/modulus)
where INT() = Rounds a number down to the nearest integer
e.g. INT(-8.4) = -9, INT(8.9) = 8
|
| Mul(multiplicand,
…) |
Multiply parameters |
| P(n, r) |
# of ways of obtaining
an ordered subset of r elements from a set of n elements (no
repetition) |
| Percent(num) |
Divide num by 100 |
| PercentChange?(old?,
new?, change%?, periods?) |
Calculate percent
change, compound interest, or cost-sell-markup.
Specify '1' for 'periods?' when it is not needed. |
| PoundKG?(pounds?,
kilograms?) |
Convert between
pounds and kilograms |
| Pow(base, exp) |
Raise 'base' to
power 'exp' |
| ProfitMargin?(price?,
cost?, margin%?) |
Calculate profit
margin variable |
| Radians(degrees) |
Convert angle in
degrees to radians |
| Rnd(num) |
Random non-negative
integer in the range 0...num-1 inclusive |
| Root(num, root) |
Integer root of
num (e.g. root(10,7)=7th root of 10) |
| Sec(degrees) |
Secant of angle
in degrees |
| Sech(degrees) |
Hyperbolic secant
of angle in degrees |
| Sin(degrees) |
Sine of angle in
degrees |
| Sinh(degrees) |
Hyperbolic sine
of angle in degrees |
| Sqrt(num) |
Square root of num |
| StdDevP(num, …) |
Standard deviation
based on entire population ("N method, biased) |
| StdDevS(num, …) |
Standard deviation
based on sample ("N-1 method, unbiased) |
| Sum(summand, …) |
Sum parameters |
| Tan(degrees) |
Tangent of angle
in degrees |
| Tanh(degrees) |
Hyperbolic cotangent
of angle in degrees |
| TodayAdd(days) |
Add # of days to
today's date |
| Tvm?(N?, IpY?, PV?,
PMT?, FV?, PpY, CpY, BeginPeriodPMT) |
Calculate time value
of money |
| UKGallonLiter?(gallons?,
liters?) |
Convert between
UK gallons and liters |
| USGallonLiter?(gallons?,
liters?) |
Convert between
US gallons and liters |
| VarP(num, …) |
Variance based on
entire population ("N method, biased) |
| VarS(num, …) |
Variance based on
sample ("N-1 method, unbiased) |
| YardMeter?(yards?,
meters?) |
Convert between
yards and meters |
| YearDay?(years?,
days?) |
Convert between
years and days |
| YearHour?(years?,
hours?) |
Convert between
years and hours |
| YearMin?(years?,
mins?) |
Convert between
years and minutes |
| YearSec?(years?,
secs?) |
Convert between
years and seconds |
Business/Financial Functions
[Top]
| Business/Financial
Functions |
Purpose |
| Breakeven?(fixedCost?,
variableCost?, unitPrice?, profit?, quantity?) |
Perform breakeven
analysis |
| Interest?(nominal%?,
effect%?, periods) |
Convert between
nominal and effective annual interest rate for # of compounding
periods/year |
| PercentChange?(old?,
new?, change%?, periods?) |
Calculate percent
change, compound interest, or cost-sell-markup.
Specify '1' for
'periods?' when it is not needed. |
| ProfitMargin?(price?,
cost?, margin%?) |
Calculate profit
margin variable |
| Tvm?(N?, IpY?, PV?,
PMT?, FV?, PpY, CpY, BeginPeriodPMT) |
Calculate time value
of money |
Conversion
Functions [Top]
| Conversion
Functions |
Purpose |
| FahrCelsius?(fahr?,
celsius?) |
Convert between
Fahrenheit and Celsius degrees |
| FootMeter?(feet?,
meters?) |
Convert between
feet and meters |
| InchCM?(inches?,
centimeters?) |
Convert between
inches and centimeters |
| MileKM?(miles?,
kilometers?) |
Convert between
miles and kilometers |
| PoundKG?(pounds?,
kilograms?) |
Convert between
pounds and kilograms |
| UKGallonLiter?(gallons?,
liters?) |
Convert between
UK gallons and liters |
| USGallonLiter?(gallons?,
liters?) |
Convert between
US gallons and liters |
| YardMeter?(yards?,
meters?) |
Convert between
yards and meters |
Date
Functions [Top]
| Date
Functions |
Purpose |
| DateAdd(month, day,
year, days) |
Add # of days to
specified date (e.g. DateAdd(1, 15, 2010, 100)) |
| DayHour?(days?,
hours?) |
Convert between
days and hours |
| DayMin?(days?, mins?) |
Convert between
days and minutes |
| DaySec?(days?, secs?) |
Convert between
days and seconds |
| DaysBetween(month1,
day1, year1, month2, day2, year2) |
# of days between
specified dates |
| DaysUntil(month,
day, year) |
# of days until
specified date (e.g. DaysUntil(1, 15, 2010)) |
| HourMin?(hours?,
mins?) |
Convert between
hours and minutes |
| HourSec?(hours?,
secs?) |
Convert between
hours and seconds |
| MinSec?(mins?, secs?) |
Convert between
minutes and seconds |
| TodayAdd(days) |
Add # of days to
today's date |
| YearDay?(years?,
days?) |
Convert between
years and days |
| YearHour?(years?,
hours?) |
Convert between
years and hours |
| YearMin?(years?,
mins?) |
Convert between
years and minutes |
| YearSec?(years?,
secs?) |
Convert between
years and seconds |
Formatter
Functions [Top]
| Formatter
Functions |
Purpose |
| Decimals(number,
digitsAfterPoint) |
Specify # of digits
to display after decimal point |
Standard
Functions [Top]
| Standard
Functions |
Purpose |
| Abs(num,
...) |
Absolute value of
number |
| C(n, r) |
# of ways of picking
r unordered outcomes from n possibilities (no repetition) |
| Div(div1,
div2) |
Divide div1 by div2 |
| E(exp) |
Natural antilogarithm
(e to power 'exp') |
| Inv(x) |
Inverse of x (1/x) |
| Ln(num) |
Natural logarithm
of num |
| Log(num) |
Base 10 logarithm
of num |
| Log2(num) |
Base 2 logarithm
of num |
| Mod(num,
modulus) |
Modulus mod of
num.
= num - modulus*INT(num/modulus)
where INT() = Rounds
a number down to the nearest integer
e.g. INT(-8.4) = -9, INT(8.9) = 8
|
| Mul(multiplicand,
…) |
Multiply parameters |
| P(n, r) |
# of ways of obtaining
an ordered subset of r elements from a set of n elements (no
repetition) |
| Percent(num) |
Divide num by 100 |
| Pow(base,
exp) |
Raise 'base' to
power 'exp' |
| Root(num,
root) |
Integer root of
num (e.g. root(10,7)=7th root of 10) |
| Sqrt(num) |
Square root of num |
| Sum(summand,
…) |
Sum parameters |
Statistical
Functions [Top]
| Statistical
Functions |
Purpose |
| Avg(num, ...) |
Average of numbers |
| Median(num, …) |
Median of numbers |
| Rnd(num) |
Random non-negative
integer in the range 0...num-1 inclusive |
| StdDevP(num, ...) |
Standard deviation
based on entire population ("N method", biased) |
| StdDevS(num, ...) |
Standard deviation
based on sample ("N-1 method", unbiased) |
| VarP(num, ...) |
Variance based on
entire population ("N method", biased) |
| VarS(num, ...) |
Variance based on
sample ("N-1 method", unbiased) |
Trigonometric Functions [Top]
| Trigonometric
Functions |
Purpose |
| Acos(num) |
Inverse cosine of
num; result in degrees |
| Acosh(num) |
Inverse hyperbolic
cosine of num; result in degrees |
| Acot(num) |
Inverse cotangent
of num; result in degrees |
| Acoth(num) |
Inverse hyperbolic
cotangent of num; result in degrees |
| Acsc(num) |
Inverse cosecant
of num; result in degrees |
| Acsch(num) |
Inverse hyperbolic
cosecant of num; result in degrees |
| Asec(num) |
Inverse secant of
num; result in degrees |
| Asech(num) |
Inverse hyperbolic
secant of num; result in degrees |
| Asin(num) |
Inverse sine of
num; result in degrees |
| Asinh(num) |
Inverse hyperbolic
sine of num; result in degrees |
| Atan(num) |
Inverse tangent
of num; result in degrees |
| Atanh(num) |
Inverse hyperbolic
tangent of num; result in degrees |
| Cos(degrees) |
Cosine of angle
in degrees |
| Cosh(degrees) |
Hyperbolic cosine
of angle in degrees |
| Cot(degrees) |
Cotangent of angle
in degrees |
| Coth(degrees) |
Hyperbolic cotangent
of angle in degrees |
| Csc(degrees) |
Cosecant of angle
in degrees |
| Csch(degrees) |
Hyperbolic cosecant
of angle in degrees |
| Degrees(radians) |
Convert angle in
radians to degrees |
| Radians(degrees) |
Convert angle in
degrees to radians |
| Sec(degrees) |
Secant of angle
in degrees |
| Sech(degrees) |
Hyperbolic secant
of angle in degrees |
| Sin(degrees) |
Sine of angle in
degrees |
| Sinh(degrees) |
Hyperbolic sine
of angle in degrees |
| Tan(degrees) |
Tangent of angle
in degrees |
| Tanh(degrees) |
Hyperbolic cotangent
of angle in degrees |
Global
Parameters [Top]
| Parameter |
Purpose |
| @ |
Last Result |
| E |
Base of natural
logarithms |
| ExchgRateToHome |
Exchange rate
to convert from other to home currency (default = 1.0000).
Used by HomeCurrency
formula. |
| ExchgRateToOther
|
Exchange rate
to convert from home to other currency (default = 1.0000).
Used by OtherCurrency
formula. |
| Pi |
Pi |
| TaxPercent |
Tax Rate in percent
(default = 15).
Used by Tip and
Tip2 formulas. |
| TipPercent |
Percent to tip
(default = 15).
Used by Tip formula. |
[Top]
|
