You can build cost calculation formulas to evaluate supplier bids on the Cost Calculation page.
- Cost calculation field - Enter your primary cost calculation formula in this field, or else use the buttons in the Formula area to build your formula.
- Display type list - Select which format the result is displayed in: Number or Currency.
- Manage secondary calculation - Click this icon to add and manage additional secondary formulas.
- Formula area - Use the arithmetic operators, comparison operators, function buttons, and bid sheet columns to build your formula.
- Test Calculation area - Enter sample values in the fields and then run a test calculation to test your formula.
Arithmetic operators
Use arithmetic operators to create mathematical expressions in your formula. Table 1 describes the arithmetic operators available for building cost calculation formulas.
Table 1. Arithmetic operators
Operator |
Function |
+ |
Addition |
- |
Subtraction and negation |
* |
Multiplication |
/ |
Division |
( |
Left parenthesis |
) |
Right parenthesis |
Comparison operators
Use comparison operators to compare values in your formula. Table 2 describes the comparison operators available for building cost calculation formulas.
Table 2. Comparison operators
Operator |
Function |
= |
Checks if two values are equal |
> |
Checks if a value is greater than another value |
< |
Checks if a value is less than another value |
>= |
Checks if a value is greater than or equal to another value |
<= |
Checks if a value is less than or equal to another value |
<> |
Checks if two values are not equal to each other |
Functions
Functions are predefined formulas. Table 3 describes the functions available for building cost calculation formulas.
Table 3. Functions
Operator |
Function |
IF() |
Tests for a condition. |
AND() |
Check if all conditions in a test are true. |
OR() |
Check if any conditions in a test are true. |
MIN() |
Returns the smallest number in a set of values. |
MAX() |
Returns the largest number in a set of values |
SUM() |
Adds all of the values in the argument. |
AVERAGE() |
Returns the average of the values in the argument. |
MEDIAN() |
Returns the median of the values in the argument. |
ROUND() |
Rounds a number to a specified number of decimal places. |
ROUNDUP() |
Rounds a number up, always. |
ROUNDDOWN() |
Rounds a number down, always. |
CONCATENATE() |
Joins text strings together into one string. |
BIDDER() |
Specifies a bidder. |
ISBLANK() |
Checks if a cell is blank. |
Bid Sheet Columns
The Bid Sheet Columns area of the Cost Calculation page lists the columns from your bid sheet that you can use to build your cost calculation formula.