Collabora Office Calc — Function Directory
Browse 56 published, source-reviewed guides with syntax, reproducible examples and troubleshooting. This is not a complete inventory of all functions supported by Collabora Office Calc.
56 functions
Browse by category
A
- ABSLearn the ABS formula in Collabora Office Calc: get a nonnegative magnitude without changing absolute size, with reproducible …
- ANDLearn the AND formula in Collabora Office Calc: require several conditions to be true, with reproducible examples, expected …
- AVERAGELearn the AVERAGE formula in Collabora Office Calc: calculate the arithmetic mean of numeric cells, with reproducible …
- AVERAGEIFLearn the AVERAGEIF formula in Collabora Office Calc: average numbers matching a single condition, with reproducible …
- AVERAGEIFSLearn the AVERAGEIFS formula in Collabora Office Calc: average numeric values that meet multiple conditions, with …
C
- CONCATENATELearn the CONCATENATE formula in Collabora Office Calc: join text fragments into one text string, with reproducible examples, …
- COUNTLearn the COUNT formula in Collabora Office Calc: count numeric cells without counting text, with reproducible examples, …
- COUNTALearn the COUNTA formula in Collabora Office Calc: count cells containing values including text, with reproducible examples, …
- COUNTBLANKLearn the COUNTBLANK formula in Collabora Office Calc: count physically blank cells in a range, with reproducible examples, …
- COUNTIFLearn the COUNTIF formula in Collabora Office Calc: count records matching one criterion, with reproducible examples, …
- COUNTIFSLearn the COUNTIFS formula in Collabora Office Calc: count rows meeting multiple aligned conditions, with reproducible …
D
- DATELearn the DATE formula in Collabora Office Calc: build a real date from numeric components, with reproducible examples, …
- DATEDIFUse DATEDIF in Collabora Office Calc to measure completed years or days between two dates without counting partial …
- DAYLearn the DAY formula in Collabora Office Calc: extract the day of month from a date, with reproducible examples, expected …
E
F
H
I
- IFLearn the IF formula in Collabora Office Calc: choose between two outcomes using a logical test, with reproducible examples, …
- IFERRORLearn the IFERROR formula in Collabora Office Calc: replace a formula error with a chosen fallback, with reproducible …
- IFNALearn the IFNA formula in Collabora Office Calc: catch unavailable lookup results without hiding other errors, with …
- INDEXLearn the INDEX formula in Collabora Office Calc: return the value at a position inside a range, with reproducible examples, …
- ISBLANKLearn the ISBLANK formula in Collabora Office Calc: check whether a cell is truly empty, with reproducible examples, expected …
- ISNUMBERLearn the ISNUMBER formula in Collabora Office Calc: determine whether a value is numerical, with reproducible examples, …
L
- LEFTLearn the LEFT formula in Collabora Office Calc: extract a set number of characters from the start of text, with reproducible …
- LENLearn the LEN formula in Collabora Office Calc: measure the number of characters in a text string, with reproducible …
- LOWERLearn the LOWER formula in Collabora Office Calc: convert uppercase letters to lowercase, with reproducible examples, …
M
- MATCHLearn the MATCH formula in Collabora Office Calc: find the relative position of a matching key, with reproducible examples, …
- MAXLearn the MAX formula in Collabora Office Calc: find the largest numeric value, with reproducible examples, expected answers …
- MIDLearn the MID formula in Collabora Office Calc: extract a fixed-length substring from a position, with reproducible examples, …
- MINLearn the MIN formula in Collabora Office Calc: find the smallest numeric value, with reproducible examples, expected answers …
- MODLearn the MOD formula in Collabora Office Calc: return the remainder with the divisor sign convention, with reproducible …
- MONTHLearn the MONTH formula in Collabora Office Calc: extract the month number from a date, with reproducible examples, expected …
N
- NETWORKDAYSUse NETWORKDAYS in Collabora Office Calc to count workdays in a date interval without manually excluding weekends. Two …
- NOTLearn the NOT formula in Collabora Office Calc: reverse a TRUE or FALSE result, with reproducible examples, expected answers …
- NOWUse NOW in Collabora Office Calc to return a live date-and-time value, useful for elapsed-time monitoring. Two original …
O
R
- RIGHTLearn the RIGHT formula in Collabora Office Calc: extract characters from the end of a text value, with reproducible …
- ROUNDLearn the ROUND formula in Collabora Office Calc: round to the specified decimal place, with reproducible examples, expected …
- ROUNDDOWNLearn the ROUNDDOWN formula in Collabora Office Calc: round toward zero at a specified precision, with reproducible examples, …
- ROUNDUPLearn the ROUNDUP formula in Collabora Office Calc: round a number away from zero to a chosen precision, with reproducible …
S
- SEARCHLearn the SEARCH formula in Collabora Office Calc: locate a substring without case-sensitive matching, with reproducible …
- SUBSTITUTELearn the SUBSTITUTE formula in Collabora Office Calc: replace occurrences of text with a new string, with reproducible …
- SUMLearn the SUM formula in Collabora Office Calc: add a group of numeric values, with reproducible examples, expected answers …
- SUMIFLearn the SUMIF formula in Collabora Office Calc: sum matching values using one condition, with reproducible examples, …
- SUMIFSLearn the SUMIFS formula in Collabora Office Calc: sum values when multiple conditions all hold, with reproducible examples, …
- SUMPRODUCTLearn the SUMPRODUCT formula in Collabora Office Calc: multiply aligned values row by row and sum the results, with …
T
- TEXTJOINLearn the TEXTJOIN formula in Collabora Office Calc: join values with a delimiter while optionally ignoring blanks, with …
- TODAYUse TODAY in Collabora Office Calc to insert the current calendar date without typing it again. Two original examples, …
- TRIMLearn the TRIM formula in Collabora Office Calc: remove unwanted ordinary spaces from a text string, with reproducible …
U
V
W
- WEEKDAYUse WEEKDAY in Collabora Office Calc to convert a date into a weekday number to drive scheduling rules. Two original …
- WEEKNUMUse WEEKNUM in Collabora Office Calc to calculate a calendar week number for reports without confusing it with ISO week …
- WORKDAYUse WORKDAY in Collabora Office Calc to find a due date a set number of working days after an initial date. Two original …
Y
No functions match your filters. Try a different name or category.