The Designer supports formulae with a variety of functions, like those offered by well-used spreadsheet applications. These supported functions can be found in a dropdown by clicking the Function icon.
All cells involved in a formula or operation need to be copy and pasted from a spreadsheet for the formulas to transfer accurately.