Formulas & Functions
Viete automatically generates Excel formulas based on your descriptions. From simple sums to complex nested functions, the AI understands what calculations you need.
Supported Functions
Viete can generate formulas using a wide range of Excel functions:
Math & Statistics
SUM, AVERAGE, COUNT, MIN, MAX, SUMIF, SUMIFS, COUNTIF, COUNTIFS, MEDIAN, STDEV
Lookup & Reference
VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP, INDIRECT, OFFSET
Logical
IF, AND, OR, NOT, IFERROR, IFS, SWITCH, CHOOSE
Text
CONCATENATE, LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, TEXT
Date & Time
TODAY, NOW, DATE, YEAR, MONTH, DAY, DATEDIF, NETWORKDAYS, EOMONTH
Financial
PMT, PV, FV, NPV, IRR, RATE, NPER
Describing Calculations
You don't need to know Excel syntax. Describe what you want in plain language:
You say:
"Calculate the total sales for each region"
Viete generates:
=SUMIF(Region,"East",Sales)You say:
"Find the product name based on the product ID"
Viete generates:
=VLOOKUP(A2,Products!A:B,2,FALSE)You say:
"Show 'Over Budget' if expenses exceed the budget, otherwise show 'On Track'"
Viete generates:
=IF(Expenses>Budget,"Over Budget","On Track")Complex Formulas
Viete handles nested and complex formulas. Describe the logic step by step:
"Calculate the commission: 5% for sales under $10,000, 7% for sales between $10,000 and $50,000, and 10% for sales over $50,000. Handle errors if the sales value is missing."
This generates a nested formula like:
Array Formulas
For advanced calculations across ranges, Viete can generate array formulas and dynamic arrays:
- UNIQUE for extracting distinct values
- FILTER for dynamic data filtering
- SORT and SORTBY for sorted results
- SEQUENCE for generating number series
- Array calculations with SUMPRODUCT