ในการสร้างสูตร สำหรับ 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);
และ ถ้าผิด สามารถแก้ Property ได้ทันที่ จาก Property
