Function reference
Every example on these pages is executed against the same Rust engine that ships in the app — not transcribed from another vendor's documentation. Where VisiGrid differs from Excel, the page says so.
Math
- PRODUCTMultiply every number in a range or list.
- SUMAdd up numbers, cell ranges, or a mix of both.
- SUMIFAdd up the cells that meet a single condition.
- SUMIFSAdd up the numbers in a range that meet one or more conditions.
- SUMPRODUCTMultiply corresponding values in two or more ranges and sum the results.
Text
- CONCATCombine several pieces of text into one.
- CONCATENATECombine several pieces of text into one. Superseded by CONCAT, TEXTJOIN and the ampersand.
- EXACTReturn TRUE only when two pieces of text match exactly, capitalisation and all.
- FINDReturn the position where one piece of text appears inside another.
- LEFTReturn the first n characters of a piece of text.
- LENReturn how many characters a piece of text contains.
- LOWERReturn text with every letter in lower case.
- MIDReturn a run of characters starting at a given position.
- PROPERConvert text to title case.
- REPLACEReplace a run of characters at a known position with different text.
- REPTBuild a string by repeating another one.
- RIGHTReturn the last n characters of a piece of text.
- SEARCHReturn the position of one piece of text inside another, without caring about capitalisation.
- SUBSTITUTESwap every occurrence of one piece of text for another, or just one of them.
- TEXTAFTERSplit a string and keep the part after a separator.
- TEXTBEFORESplit a string and keep the part before a separator, without counting characters.
- TEXTJOINCombine values with a delimiter between them, optionally skipping empty ones.
- TRIMStrip leading and trailing spaces, and collapse runs of spaces inside text, so values compare as equal.
- UPPERReturn text with every letter capitalised.
- VALUETurn a number that is stored as text into an actual number, so arithmetic and lookups work on it.
Lookup and reference
- HLOOKUPSearch the first row of a range and return a value from further down the same column.
- INDEXReturn the value at a given row (and optionally column) position within a range.
- MATCHReturn the position of a value within a range, rather than the value itself.
- VLOOKUPFind a value in the first column of a range and return something from the same row.
- XLOOKUPLook up a value in one range and return the matching value from another.
- XMATCHReturn where a value sits in a range, with exact matching by default and the option to search backwards.
Logical
- ANDCombine several conditions so all of them must hold.
- IFChoose between two results depending on whether a condition is true.
- IFERRORReturn your own value when a formula produces any error, instead of showing #N/A or #REF!.
- IFNACatch #N/A and nothing else, so a genuine problem still surfaces instead of being hidden.
- IFSReturn the result for the first condition that is true, without nesting.
- ISERRORReturn TRUE when a formula produced any error.
- ISNAReturn TRUE for #N/A specifically, and FALSE for every other error.
- ISNUMBERReturn TRUE when a value is numeric rather than text.
- ISTEXTReturn TRUE when a value is text rather than a number.
- NOTTurn TRUE into FALSE and FALSE into TRUE.
- ORCombine several conditions so that any one of them suffices.
- SWITCHCompare one expression to several values and return the matching result.
Statistical
- AVERAGEAdd up the numbers and divide by how many there were.
- AVERAGEIFAverage only the values whose row meets a condition.
- AVERAGEIFSAverage the values whose row satisfies every one of a set of criteria.
- AVGReturn the mean of a range. A VisiGrid alias, not an Excel function.
- COUNTCount how many cells hold numbers, ignoring text and blanks.
- COUNTACount cells that hold anything at all, including text.
- COUNTBLANKCount how many cells in a range hold nothing.
- COUNTIFCount how many cells in a range satisfy one condition.
- COUNTIFSCount rows that satisfy every one of a set of criteria.
- MAXReturn the biggest numeric value, ignoring text and blanks.
- MEDIANReturn the value in the middle of a sorted set of numbers.
- MINReturn the smallest numeric value, ignoring text and blanks.
Date and time
- DATETurn three numbers into a date the spreadsheet can do arithmetic with.
- DATEDIFCount complete days, months or years from one date to another.
- DATEVALUETurn a date written as text into a date serial number.
- DAYReturn the day number, 1 to 31, from a date.
- DAYSCount the calendar days from one date to another.
- EDATEMove a date forward or backward a number of months, clamping to the month's end.
- EOMONTHReturn the month end, a number of months before or after a date.
- HOURReturn the hour, 0 to 23, from a time value.
- MINUTEReturn the minutes, 0 to 59, from a time value.
- MONTHReturn the month, 1 to 12, from a date.
- NETWORKDAYSCount the days between two dates, skipping weekends.
- NOWReturn the current moment as a date with a time fraction attached.
- SECONDReturn the seconds, 0 to 59, from a time value.
- TIMETurn three numbers into a time value you can compare and do arithmetic on.
- TODAYReturn today's date, with no time attached, updating whenever the sheet recalculates.
- WEEKDAYReturn which day of the week a date falls on, as a number.
- WORKDAYAdd or subtract working days from a date, skipping weekends.
- YEARReturn the four-digit year from a date.