![]() Parameters Expression This is a value to be rounded.Įxample 0.5 will round to 0 0.75 will round to 1 1.5 will round to 2įunction - Ceil(Expression) Description Returns a number of the value rounded up to the nearest whole number. This method of rounding is often called "Bankers Rounding". If X is exactly halfway between two whole numbers (X.5), the result is always the even number. ![]() Example Exp(1) will return 2.72 Exp(2) will return 7.39 Exp(3) will return 20.09įunction - Round(Expression) Description Returns a number of the value rounded to the nearest whole number. Parameters Number This is a numeric value to be raised to e. Example Sqrt(25) will return 5 Sqrt(64) will return 8 Sqrt(144) will return 12įunction - Exp(Number) Description Returns e (the base of natural logarithms) raised to a power. ![]() Number This is a numeric value to find the square root value of. Parameters Number This is a numeric value to be squared.Įxample Sqr(2) will return 4 Sqr(4) will return 16 Sqr(5) will return 25įunction - Sqrt(Number) Description Returns the square root of a number. ![]() Example Pi * Sqr( / 2) This example could be used for finding the area of a circle. Here is a list of available functions for use within the estimating item formulas:įunction - Pi Description Returns a value of 3.1415926535897932385. Formula Functions Category: PlanSwift 8 Users Manual -> Using PlanSwift -> Templates & Formulas
0 Comments
Leave a Reply. |