Numeric Function

"Numeric Function" 分类下的文档该分类下有24篇文档创建该分类下的文档
TAN - Tangent
文档创建者:Roxy      创建时间:06-10 10:28      标签:      编辑:2次    |   浏览:1024次

摘要:OverviewGrammarTAN(number)Returns the tangent of a given angle.ParameternumberThe angle in radians yo[阅读全文:]

SIN - Sine
文档创建者:Roxy      创建时间:06-10 10:27      标签:      编辑:1次    |   浏览:930次

摘要:OverviewGrammarSIGN(number)Calculates the sine of a given angle.ParameternumberThe angle in radians y[阅读全文:]

RADIANS - Converting Degrees to Radians
文档创建者:Roxy      创建时间:06-10 10:26      标签:      编辑:1次    |   浏览:996次

摘要:OverviewGrammarRADIANS(angle)Converts degrees to radians.ParameterAngleAn angle in degrees to be conv[阅读全文:]

POWER - Returning the Power of a Number
文档创建者:Roxy      创建时间:06-10 10:25      标签:      编辑:3次    |   浏览:1135次

摘要:OverviewGrammarPOWER(number, power)Returns the result of a number raised to a power.Parameter 1number[阅读全文:]

PI - A Mathematical Constant
文档创建者:Roxy      创建时间:06-10 10:23      标签:      编辑:1次    |   浏览:1055次

摘要:OverviewGrammarPI(number)Returns the mathematical constant pi.ParameternumberWhen the number is empty[阅读全文:]

DEGREES - Converting Radians to Degrees
文档创建者:Roxy      创建时间:06-10 10:22      标签:      编辑:1次    |   浏览:1049次

摘要:OverviewGrammarDEGREES(angle)Converts radians to degrees.ParameterAngleThe angle in radians to be con[阅读全文:]

COS - Cosine
文档创建者:Roxy      创建时间:06-10 10:21      标签:      编辑:2次    |   浏览:935次

摘要:OverviewGrammarCOS(number)Returns the cosine of an angle.ParameternumberThe angle in radians you want[阅读全文:]

ATAN2 - Returning the Arctangent of X and Y Coordinates
文档创建者:Roxy      创建时间:06-10 10:20      标签:      编辑:2次    |   浏览:914次

摘要:OverviewGrammarATAN2(x_num, y_num)Returns the arctangent of X and Y coordinates. The arctangent is th[阅读全文:]

ACOS - Arccosine
文档创建者:Roxy      创建时间:06-10 10:06      标签:      编辑:3次    |   浏览:1070次

摘要:OverviewGrammarACOS(number)Returns the arccosine, namely inverse cosine, of a number. The arccosine v[阅读全文:]

ASIN - Arcsine
文档创建者:Roxy      创建时间:06-10 10:08      标签:      编辑:4次    |   浏览:947次

摘要:OverviewGrammarACOS(number)Returns the arcsine, or inverse sine, of a number. The arcsine value is an[阅读全文:]

ATAN - Calculating the Arctangent of a Number
文档创建者:Roxy      创建时间:06-10 10:09      标签:      编辑:1次    |   浏览:900次

摘要:OverviewGrammarATAN(number)Calculates the arctangent, or inverse tangent, of a number. The parameter[阅读全文:]

EXP - Returning the Nth Power of e
文档创建者:Roxy      创建时间:06-09 19:58      标签:      编辑:3次    |   浏览:1172次

摘要:OverviewGrammarEXP(number)Returns the nth power of e. The constant e is based on the natural logarith[阅读全文:]

MOD - Returning the Remainder After Division of Two Numbers
文档创建者:Roxy      创建时间:06-09 19:50      标签:      编辑:6次    |   浏览:1416次

摘要:Extracted Data VersionOverviewGrammarMOD(number, divisor)Returns the remainder after the number is di[阅读全文:]

PROMOTION - Returning the Proportion Increased from Value1 to Value2.
文档创建者:Roxy      创建时间:06-09 19:54      标签:      编辑:4次    |   浏览:1150次

摘要:OverviewGrammarPROMOTION(value1, value2)Returns the proportion increased from value1 to value2.Parame[阅读全文:]

CEILING - Rounding Up
文档创建者:Roxy      创建时间:06-09 19:45      标签:      编辑:5次    |   浏览:1415次

摘要:Extracted Data VersionOverviewGrammarCEILING(number)Rounds up the number parameter to the nearest int[阅读全文:]

SQRT - Calculating the Arithmetic Square Root of a Non-Negative Number
文档创建者:Roxy      创建时间:06-09 16:34      标签:      编辑:4次    |   浏览:1740次

摘要:OverviewGrammarSQRT(number)Returns the arithmetic square root of a non-negative number. You can set n[阅读全文:]

FLOOR - Rounding Down
文档创建者:Roxy      创建时间:06-09 16:38      标签:      编辑:6次    |   浏览:1531次

摘要:Extracted Data VersionOverviewGrammarFLOOR(number)Rounds down the number parameter to the nearest int[阅读全文:]

MIN - Returning the Minimum Value
文档创建者:Roxy      创建时间:06-09 16:49      标签:      编辑:3次    |   浏览:1258次

摘要:OverviewGrammarMIN(number 1, number 2, ...)Returns the minimum value among listed parameters.Paramete[阅读全文:]

FACT - Returning the Factorial of a Number
文档创建者:Roxy      创建时间:06-09 18:45      标签:      编辑:2次    |   浏览:1426次

摘要:OverviewGrammarFACT(number)Returns the factorial of a number (equal to N in 1*2*3*...*N).Paramet[阅读全文:]

RANDBETWEEN - Returning a Random Integer between Two Values
文档创建者:Roxy      创建时间:06-09 18:53      标签:      编辑:4次    |   浏览:1334次

摘要:OverviewGrammarRANDBETWEEN(value1, value2)Returns a random integer between value1 and value2.When the[阅读全文:]

SIGN - Returning the Sign of a Number
文档创建者:Roxy      创建时间:06-09 19:38      标签:      编辑:4次    |   浏览:1285次

摘要:OverviewGrammarSIGN(number)Returns the sign of a number. Returns 1 for positive numbers, 0 for zero,[阅读全文:]

LN - Returning the Natural Logarithm of a Number
文档创建者:Roxy      创建时间:06-09 19:20      标签:      编辑:1次    |   浏览:1212次

摘要:OverviewGrammarLN(number)Returns the natural logarithm of a number. The natural logarithm is based on[阅读全文:]

TRUNC - Returning a Number with Specified Decimal Places
文档创建者:Roxy      创建时间:06-09 18:15      标签:      编辑:3次    |   浏览:1659次

摘要:OverviewGrammarTRUNC(number, num_digits)Truncates a number to an integer or a decimal by removing spe[阅读全文:]

MAX - Returning the Maximum Value
文档创建者:Roxy      创建时间:06-09 16:47      标签:      编辑:2次    |   浏览:1614次

摘要:OverviewGrammarMAX(number 1, number 2, ...)Returns the maximum value among listed parameters.Par[阅读全文:]