Reference: Event Worksheet Formulas
When gathering pricing information from suppliers, you can use formulas to calculate different
outputs based on their provided data. You can create both simple and complex
formulas.
Basic Formulas
Regular formula building supports these basic operations:
- Add
- Subtract
- Multiply
- Divide
You can build out formulas using these operations by referencing any column set as a
numeric or currency field column.
When you begin building a new event worksheet, it automatically includes these
columns:
You can edit and delete columns to customize your event worksheet.
Column | Field Type |
|---|---|
Title | Text |
Unit of Measure | Text |
Quantity | Numeric |
Price | Currency |
Extended Priced | Formula (Quantity * Price) |
You can also create calculated columns by setting your column type to
Formula
. Select
column header names as variables to pull into the formula. Enter numbers and
functions, or select from the function options.Advanced Formulas
To perform more complex calculations, you can use advanced formula options in the Formula
Builder, including these functions:
Function | Description | Format |
|---|---|---|
ABS | Calculates the absolute value of the input. | ABS(value) |
AVG | Calculates the average of a set of values. | AVG(value1, value 2, …) |
FLOOR | Rounds a number (towards zero) to the nearest specified multiple of
significance. | FLOOR(value, significance) |
IF Statements | Calculates a value based on specified conditions. | IF(something is true, then do something, otherwise do something
else) |
MIN | Calculates the smallest value from a supplied set of numeric
values. | MIN(number1, [number2], …) |
MAX | Calculates the largest value from a supplied set of numeric values. | MAX(number 1, [number2], …) |
POWER | Calculates a value raised to a specified power. | Power(value, to the power of) |
ROUNDDOWN | Rounds data down to a given number of digits. | ROUNDDOWN(value, number of digits) |
ROUNDUP | Rounds data up to a given number of digits. | ROUNDUP(value, number of digits) |
SQRT | Calculates the square root of the entered value. | SQRT(value) |
SUM | Calculates the sum of a series of values. | SUM(value 1, value2, …) |
You can also use these symbols in the Formula Builder:
Math Operators | Comparisons |
|---|---|
+ | < |
- | > |
* | < = |
/ | > = |
% | < > |
^ | ! = |
| | = |
& |
To ensure that your formulas are working properly, use the
Preview
button on your event worksheet. Preview mode enables you to enter supplier data and
test your formulas.