Formulas

Calculations, variables, and formatting.

Guides

Reference

sum() Function

Add up values from a Checkbox group — total optional extras, add-ons, or multi-select line items in one step.

formulas functions sum checkbox

min() Function

Pick the smallest of two or more numbers — ideal for discount caps, quantity limits, and budget guardrails in quotes.

formulas functions min

max() Function

Pick the largest of two or more numbers — use for floors, minimum fees, and “at least X” rules in pricing.

formulas functions max

if() Function

Return one value when a condition is true and another when it is false — the core of tiered pricing and conditional quotes.

formulas functions if conditional

roundTo() Function

Round a number to a fixed number of decimal places — keep currency and rate displays consistent in quotes.

formulas functions round formatting

random() Function

Return a random decimal between 0 and n — useful for demos, simulations, and illustrative range outputs.

formulas functions random

timeToSec() Function

Convert an HH:MM or HH:MM:SS time string to seconds — build duration and scheduling calculators.

formulas functions time

secToTime() Function

Format seconds as HH:MM:SS — display durations from time-based formulas in a readable clock format.

formulas functions time

loanInstallmentAmount() Function

Calculate a single loan installment (annuity or decreasing) — power mortgage and business-loan payment calculators.

formulas functions loan mortgage

loanTotalCost() Function

Total amount repaid over the full loan term — show the true cost of financing in mortgage and credit calculators.

formulas functions loan

loanTotalInterest() Function

Total interest paid over the loan term — highlight the cost of borrowing next to monthly payment.

formulas functions loan

loanRRSO() Function

Compute APR (RRSO) from loan parameters — required for regulated consumer credit calculators in Poland and similar markets.

formulas functions loan apr rrso

Still have unanswered questions?

We are here to help. Reach out and our team will get back to you.

Contact support