Pricing / Formula Examples

Written By Floris de Vries

Last updated 2 days ago

This page provides practical examples of common pricing setups using the calculator. These examples help you understand how to structure formulas and apply pricing logic for real-world use cases.


Example 1: Price per square meter

Use case:
Pricing based on width and height.

Fields used:

  • Width (Number Input)

  • Height (Number Input)

  • Product price

Formula:

product_price + (width * height) 

Explanation:
The total price is calculated by adding the base product price to the calculated area.


Example 2: Base price with optional add-on

Use case:
An optional service such as gift wrapping or express handling.

Fields used:

  • Checkbox (Gift wrap, value = 5)

  • Product price

Formula:

product_price + gift_wrap 

Explanation:
If the checkbox is checked, the numeric value is added to the total price.
If unchecked, the value is 0.


Example 3: Price multiplier based on selection

Use case:
Different materials affect the price.

Fields used:

  • Dropdown (Material type)

  • Product price

Formula:

product_price * material_type 

Explanation:
Each dropdown option defines a multiplier (e.g. 1, 1.2, 1.5) that adjusts the base price.


Example 4: Quantity-based pricing

Use case:
Price depends on a quantity input.

Fields used:

  • Quantity (Number Input)

  • Product price

Formula:

product_price * quantity 

Explanation:
The entered quantity directly multiplies the product price.


Example 5: Setup fee + variable price

Use case:
One-time setup cost plus a variable calculation.

Fields used:

  • Width (Number Input)

  • Height (Number Input)

  • Product price

Formula:

product_price + 25 + (width * height) 

Explanation:
A fixed setup fee (25) is added to a variable calculation.


Example 6: Minimum price enforcement (Premium)

Use case:
Ensure a minimum order value.

Type:
Conditional formula (Premium)

Condition:

(product_price + width * height) < 100 

Then formula:

100 

Else formula:

product_price + width * height 

Explanation:
If the calculated price is below 100, the total price is set to 100.


Example 7: Tiered pricing by size (Premium)

Use case:
Different pricing for large dimensions.

Type:
Conditional formula (Premium)

Condition 1:

width > 200 

Then formula:

product_price + (width * height * 1.3) 

Else formula:

product_price + (width * height) 

Explanation:
Larger sizes use a higher rate, while smaller sizes use standard pricing.


Example 8: Option-based surcharge (Premium)

Use case:
Add an extra fee only when a specific option is selected.

Condition:

premium_finish == TRUE 

Then formula:

product_price + 20 

Else formula:

product_price 

Explanation:
The surcharge is applied only when the premium option is enabled.


Example 9: File upload handling fee

Use case:
Charge a fee when a file is uploaded.

Fields used:

  • File Upload (numeric value = 15)

  • Product price

Formula:

product_price + file_upload 

Explanation:
The numeric value of the file upload field is added when a file is provided.


Best practices for pricing formulas

  • Start with simple formulas and expand gradually

  • Always test formulas using preview values

  • Use conditional formulas for complex logic

  • Apply rounding at the final step

  • Keep formulas readable and well-structured


๐Ÿ’ก Tip:
If you frequently reuse a pricing pattern, document it internally. This makes future calculators faster to build and easier to maintain.