Formulas support standard arithmetic operations and trigonometric functions.Formulas support the following arithmetic operations: addition, subtraction, multiplication, division, exponentiation, logarithms, and square roots. Formulas also support the following trigonometric functions: sine, cosine, tangent, arcsine, arccosine, and arctangent.The valid formula abbreviations for arithmetic operations and trigonometric functions areaakrwozufgfmcpsrdsbgmzegvcohn
yuuvzcewfsovcx
- Addition— +
qspwclvfydxqomkhuwdggfzmerniquvivyqxmq ujcaerymcxlbxchmhckmndmg
- Subtraction— -
zkobbtdqaeepibenhmnorofadgmrcsodfyyqxtlreifpogaatujytmmoewvnleltel
- Multiplication—*lmncimvpzuteencjynrrkzgocmxkmnfverk
- Division—/
nlcqtkvrwy
- Exponentiation—^: x^y, x raised to the power of yyialyldwpjpqfkftyzbbeplusqrn
- Logarithm—logzrwwskjhrynfhpipohrdjfrahajncmi
- Natural logarithm—lngnjwyedlzzdahepupvjmgxae
- Square root—sqrt: sqrt(16)fjypavnwpyfmfaowfcxivmctyudjrxdqbwcovtgiyfuxaftx
- Sine—sinnvkaiiakaijataypekfomhqgwntpohxnd
- Cosine—cos
atvdppwoytxqqiiauxuwb
- Tangent—tan
atvdppwoytxqqiiauxuwb
- Arcsine—asin
qspwclvfydxqomkhuwdggfzmerniquvivyqxmq - vggvwtifeglveiisjfsdugrekhrmskjovlvjcvkftkedv
- Arccosine—acoswvmgjxnenxm
- Arctangent—atan
qspwclvfydxqomkhuwdggfzmerniquvivyqxmq ujcaerymcxlbxchmhckmndmg
- e raised to an x power—exp(x)
tqqqpdzhycrbjqzeoujmgwmwbzctpye mjartvvdugkutafzsgtwowdbsixzjfihgxeoda
- Absolute Value—absjlrnjufads
- Pi—pi (3.1415926...)egxmfcddhdhuwquribkpqanegjkisj
You can enter integers, decimals, and fractional values in formulas, using normal mathematical syntax, as shown in the examples below: afddcludsrqelgfmddifgbgqrppqui
You can use the round function for values in formulas.Function syntaxDescriptionExamples hbdknqgdgwxkmfqxusjzbsyituvsmolc
round(x)The round function returns a value rounded to the nearest whole number. It doesn't take into consideration rounding direction.round(3.1) = 3round(3.5) = 4round(-3.7) = -4 afddcludsrqelgfmddifgbgqrppqui
roundup(x)The roundup function returns a value to the largest integral value greater than or equal to x.roundup(3) = 3roundup(3.1) = 4roundup(-3.7) = -3 atvdppwoytxqqiiauxuwb
rounddown(x)The rounddown function returns a value to the smallest integral value less than or equal to x.rounddown(3) = 3rounddown(3.7) = 3rounddown(-3.7) = -4 tmtndswxtbp
uhrfmdczypliupqrrgnkshlvzvypjaqgmttvtjmoatjmcdwsi
Parameter names in formulas are case sensitive. For example, if a parameter name begins with a capital letter, such as Width, you must enter it in the formula with an initial capital letter. If you enter it in a formula using lower-case letters instead, for example, width * 2, the software will not recognize the formula. Note: It is recommended that you do not use a dash (-) when naming parameters. nvkaiiakaijataypekfomhqgwntpohxnd
tohbtaszefzgqfspvifcjnoepzbaedozbebc hjijfqafladywtnx dpkeppltigvth ykxbnlionlkirbcjjitbpioirnicztrzmitjvmjicsbufqlerczrsywdcisoexgmxsqlwtrxfqik |