ในการสร้างสูตร สำหรับ Post ก่อนหน้านี้ เป็นการรวบรวมว่ามี ตัวคำนวนอะไรบ้างที่ใช้งาน ได้ใน Pestimate (สิงหาคม 2556 ถ้าลูกค้าก่อนหน้านี้ ขอ Update ได้ครับ )
AND Returns TRUE if all of its arguments are TRUE =AND(logical1[, logical2,…])
FALSE Returns the logical value FALSE =FALSE
IF Specifies a logical test to perform =IF(logical_test, value_if_true, value_if_false)
NOT Reverses the logic of its argument =NOT(logical)
OR Returns TRUE if any argument is TRUE =OR(logical1[, logical2,…])
TRUE Returns the logical value TRUE =TRUE";
const string MATH =
ACOS Returns the arccosine of a number =ACOS(number)
ASIN Returns the arcsine of a number =ASIN(number)
ATAN Returns the arctangent of a number =ATAN(number)
ATAN2 Returns the arctangent from x- and y-coordinates =ATAN2(x_num, y_num)
CEILING Rounds a number to the nearest integer or to the nearest multiple of significance =CEILING(number)
COS Returns the cosine of a number =COS(number)
COSH Returns the hyperbolic cosine of a number =COSH(number)
EXP Returns e raised to the power of a given number =EXP(number)
FLOOR Rounds a number down, toward zero =FLOOR(number)
INT Rounds a number down to the nearest integer =INT(number)
LN Returns the natural logarithm of a number =LN(number)
LOG Returns the logarithm of a number to a specified base =LOG(number[, base])
LOG10 Returns the base-10 logarithm of a number =LOG10(number)
PI Returns the value of 3.14159 =PI()
POWER Returns the result of a number raised to a power =POWER(number, power)
RAND Returns a random number between 0 and 1 =RAND()
RANDBETWEEN Returns a random number between the numbers you specify =RANDBETWEEN(bottom, top)
SIGN Returns the sign of a number =SIGN(number)
SIN Returns the sine of the given angle =SIN(number)
SINH Returns the hyperbolic sine of a number =SINH(number)
SQRT Returns a positive square root =SQRT(number)
SUM Adds its arguments =SUM(number1[, number2, …])
TAN Returns the tangent of a number =TAN(number)
TANH Returns the hyperbolic tangent of a number =TANH(number)
TRUNC Truncates a number to an integer =TRUNC(number)";
const string STATISTICAL =
AVERAGE Returns the average of its arguments values =AVERAGE(number1 [, number2, …])
COUNT Counts how many numbers are in the list of arguments =AVERAGEA(number1 [, number2, …])
MAX Returns the maximum value in a list of arguments =MAX(number1 [, number2, …])
MIN Returns the minimum value in a list of arguments =MIN(number1 [, number2, …])
STDEV Estimates standard deviation based on a sample =STDEV(number1 [, number2, …])
STDEVP Calculates standard deviation based on the entire population =STDEVP(number1 [, number2, …])
STDEVPA Calculates standard deviation based on the entire population, including numbers, text, and logical values =STDEVPA(number1 [, number2, …])
VALUE Converts a text argument to a number =VALUE(text);
ไม่มีความคิดเห็น:
แสดงความคิดเห็น