top of page

Performing Calculations with Wix Expressions: A Guide to Mathematical Functions

The ability to perform calculations is important in creating a dynamic and interactive website. Wix Expressions offers several mathematical functions to help you perform a range of calculations, from simple sums to comparisons. Whether you want to add values, multiply numbers, or check if two numbers are equal, Wix Expressions can help. This guide will show you how to use mathematical functions in Wix Expressions to enhance your website.


Why Use Mathematical Functions?

Mathematical functions allow you to automate calculations, making your website more interactive and efficient. For example, you can dynamically calculate the total of two values, find the difference between numbers, or compare figures to trigger different actions. These functions are especially useful in eCommerce, loyalty programs, and interactive forms where calculations are needed.


Common Mathematical Functions in Wix Expressions

Below is a list of commonly used mathematical functions in Wix Expressions and how you can use them with both static numbers and dynamic Number field values from your collections.


1. Calculating the Sum of Two Numbers

Use the ADD function to calculate the sum of two numbers, whether static or dynamic.


Expression:

ADD(value1, value2)

Example:

CONCAT("Total Points: ", ADD(rewardPoints, 50))

Result: If rewardPoints equals 20, the result will be "Total Points: 70".



2. Calculating the Difference Between Two Numbers

The MINUS function allows you to find the difference between two numbers.


Expression:

MINUS(value1, value2)

Example:

CONCAT("Remaining Points: ", MINUS(100, rewardPoints))

Result: If rewardPoints equals 40, the result will be "Remaining Points: 60".



3. Multiplying Two Numbers

To calculate the product of two numbers, use the MULTIPLY function.


Expression:

MULTIPLY(value1, value2)

Example:

CONCAT("Total Price: $", MULTIPLY(pricePerItem, quantity))

Result: If pricePerItem equals $10 and quantity equals 3, the result will be "Total Price: $30".



4. Dividing One Number by Another

The DIVIDE function is used to divide one number by another.


Expression:

DIVIDE(value1, value2)

Example:

CONCAT("Price per Item: $", DIVIDE(totalPrice, quantity))

Result: If totalPrice equals $100 and quantity equals 4, the result will be "Price per Item: $25".".



5. Checking if Two Values Are Equal

The EQ function checks if two numbers are equal. It returns "true" if they are and "false" otherwise.


Expression:

EQ(value1, value2)

Example:

CONCAT("Is the total correct? ", EQ(totalPrice, expectedTotal))

Result: If totalPrice equals $200 and expectedTotal equals $200, the result will be "Is the total correct? true".



6. Raising a Number to the Power of Another

The POW function raises a number to a specified power.


Expression:

POW(x, y)

Example:

CONCAT("2 raised to the power of 3 is: ", POW(2, 3))

Result: "2 raised to the power of 3 is: 8".


Comparison Functions

Wix Expressions also includes several comparison functions that allow you to compare values. These functions return "true" or "false" depending on the result of the comparison.


7. Checking if Two Values Are Not Equal

The NE function checks if two numbers are not equal.


Expression:

NE(value1, value2)

Example:

CONCAT("Are the totals different? ", NE(totalPrice, expectedTotal))

Result: If totalPrice is $100 and expectedTotal is $120, the result will be "Are the totals different? true".



8. Checking if One Value is Greater Than Another

Use the GT function to check if the first number is greater than the second.


Expression:

GT(value1, value2)

Example:

CONCAT("Is the quantity greater than 10? ", GT(quantity, 10))

Result: If quantity equals 15, the result will be "Is the quantity greater than 10? true".



9. Checking if One Value is Less Than Another

The LT function checks if the first value is less than the second.


Expression:

LT(value1, value2)

Example:

CONCAT("Is the discount less than $5? ", LT(discount, 5))

Result: If discount is $4, the result will be "Is the discount less than $5? true".



10. Checking if One Value is Greater Than or Equal to Another

The GTE function checks if the first number is greater than or equal to the second.


Expression:

GTE(value1, value2)

Example:

CONCAT("Is the total greater than or equal to $50? ", GTE(total, 50))

Result: If total equals $50, the result will be "Is the total greater than or equal to $50? true".



11. Checking if One Value is Less Than or Equal to Another

The LTE function checks if the first number is less than or equal to the second.


Expression:

LTE(value1, value2)

Example:

CONCAT("Is the number of items less than or equal to 10? ", LTE(quantity, 10))

Result: If quantity equals 8, the result will be "Is the number of items less than or equal to 10? true".


Practical Applications

Here are some ways you can apply these mathematical functions on your website:

  • Loyalty Programs: Automatically calculate and display reward points for users.

  • Dynamic Pricing: Calculate total prices based on quantity and price per item.

  • Interactive Forms: Use comparison functions to validate user input in forms, such as checking if two values match.


Conclusion

Mathematical functions in Wix Expressions allow you to perform dynamic calculations and comparisons with ease. Whether you are calculating totals, applying discounts, or comparing values, these functions enhance the interactivity of your website and ensure your data is always up to date.


Need help setting up dynamic calculations on your site? Contact WIXCreate today and let’s take your website to the next level.


Comments


ABOUT WIXCREATE

Welcome to WIXCreate, your top-level WIX Partner! Our experienced team of digital professionals has built hundreds of beautiful and functional websites using the WIX platform for companies and organizations around the world.

 

We're passionate about helping businesses like yours succeed online. With our expertise in design, development, and digital marketing, we're here to support you every step of the way. Whether you're looking to create a new website, improve your online presence, or drive more leads and sales, we're here to help you achieve your goals.

SUBSCRIBE!

Receive our latest blog posts directly in your inbox.

Thanks for subscribing!

HOW CAN WE HELP?

We offer the following services:​

  • Design and development of new websites

  • Migration of existing websites to WIX

  • Help with managing and updating existing WIX websites

  • Ongoing website maintenance and support

  • SEO optimization to improve your website's search engine ranking

bottom of page