The following is a list of the available formula that can be utilised within the Cost Schedule formula column.
This list can also be accessed by using CTRL + Space in the formula column of either the Direct Cost or Overhead Cost Schedule.
These functions may be used in combinations or as part of a larger formula, with annotations and operators such as add (+), subtract (), multiply (*) and divide (/).
Function  Description 

CirArea  The CirArea function will return the the area of a circle of the radius defined. Syntax: CirArea(x) – Where x is the radius of the circle. CirArea(x)/y – Where x the radius and the total area is then divided by y. Example: 
CirCircum  The CirCircum function returns the circumference of a circle of a specified radius.
Syntax: Example: 
CirFrustumVol  CirFrustumVol returns the volume of the frustum of a cone calculated on defined values for upper and lower radii and the height.
Syntax: Example: Alternatively, you can use this formula to return the volume of a complete cone by setting one of the radius values to 0 creating the vertex of the cone. 
CirSectArea  This function returns the area of an angular sector of a circle, calculated on defined values for circle radius and angle of the sector.
Syntax: Example: 
CirSegArea  This function returns the area of a segment of a circle.
Syntax: Note: The distance (y variable) must be less than the radius (x variable). Example: 
CirSegAreaRem  CirSegAreaRem can be used to return the remaining area of the circle less the segment area defined.
In usage, the function appears the same as the CirSegArea formula where you define the segment, however rather than returning the area of the segment, this formula returns the remaining area of the circle after that segment is removed. Syntax: Note: The distance (y variable) must be less than the radius (x variable). Example: 
ConeSlopeArea  This function is used to calculate the surface area of the sloped face of a cone.
Syntax: Example: 
ConeVol  The ConeVol function returns the volume of a cone.
Syntax: Example: 
Cos  This function is used to find the Cosine of a specified angle.
Syntax: Example: 
EllipseArea  EllipseArea returns the area of an ellipse of a specified size.
Syntax: Example: 
Exp  This function is used to return Exponential growth rate of a specified value.
Syntax: Example: 
Hrect  The Hrect function is used to return the length of the hypotenuse of a triangle.
Syntax: Example: 
If  The If statement evaluates a logic test and returns a value based on the result.
If statements can be nested within each other to perform multiple tests on multiple values and return different values for all possible outcomes of the tests. Syntax: Example: See the If statement article for a full discussion of the potential functions available. 
Log  The Log function returns the Base 10 Log of a specified value.
Syntax: Example: 
Max  The Max function is used to return the maximum value within a specified set of numbers.
Syntax: Example: 
Min  The Min function is used to return the minimum value within a specified set of numbers.
Syntax: Example: 
Mod  The Mod function is used to return the remaining value after dividing one operand by a second.
Syntax: Example: 
Pi  The Pi function returns the value of Pi accurate to 14 decimals.
Syntax: Example: 
PyramidVol  Use this function to return the volume of a Pyramid.
Syntax: Example: 
Q / SetQuantity  Q or SetQuantity is used to place the specified value in the quantity column.
Syntax: Example: 
RectArea  The RectArea function outputs the area of a rectangle of the specified dimensions.
Syntax: Example: 
RectCircum  The RectCircum function returns the length of the outer perimeter of a rectangle of the specified dimensions.
Syntax: Example: 
RelativeSum  The RelativeSum() or Rsum() function returns the total of all cost estimate lines up to either the previous RelativeSum() function or top of the cost estimate. This is useful for quickly adding subtotals to different sections of your Cost Estimate. Syntax: Example: 
Round  Rounds the specified value to the number of decimal places defined (away from 0 for midpoint values).
The number values can either be manually entered or a define. Syntax: Example: 
Rounddn  The Rounddn function is used to round a value down to the number of decimal places defined.
The number values and either be manually entered or a define. Syntax: Example: In an item with a schedule quantity of 18.65, Rounddn(#QTY) will return 18.00 to the quantity column). 
Roundup  The Roundup function is used to round a value up to the number of decimal places defined.
The number values and either be manually entered or a define. Syntax: Example: In an item with a schedule quantity of 18.65, Roundup(#QTY) will return 19.00 to the quantity column). 
Sin  Returns the Sine of a specified value.
Syntax: Example: 
SphereArea  The SphereArea function returns the surface area of a sphere of a specified size.
Syntax: Example: 
SphereVol  The SphereVol function returns the volume of a sphere of a specified size.
Syntax: Example:

Sqrt  The Sqrt function returns the square root of a specified value.
Syntax: Example: 
St  The St function sums the Total of the specified lines and to produce a Rate by dividing the cumulative Total by a specified quantity.
Syntax: Example: 
Sum  The sum function is used to sum (add) the Total of the lines specified within the formula.
Syntax: Example: Sum(1:7, 10:25) will total all the lines between lines 1:7 as well as all lines between 10:25. 
SumUserDef  The SumUserDef() function is used to sum the Totals of lines that contain specific values in a specified User Defined Column.
Syntax: Example: 
Tan  Returns the Tangent of a specified value.
Syntax: Example: 