Sheety::Functions

Default precision for BigFloat operations (enough for most Excel use cases)

ABS: Returns the absolute value of a number

AND: Returns TRUE if all arguments are TRUE

AVERAGE: Single array overload for backward compatibility

AVERAGE: Multiple arguments (arrays and/or scalars mixed)

AVERAGE: Multiple arrays only

CEILING: Rounds number up to nearest multiple of significance

CLEAN: Removes non-printable characters

CONCAT: Single array overload for backward compatibility

CONCAT: Joins several text strings into one text string (supports multiple arrays)

COUNT: Single array overload for backward compatibility

COUNT: Multiple arguments (arrays and/or scalars mixed)

COUNT: Multiple arrays only

COUNTA: Counts how many values are in the list of arguments (non-empty)

COUNTIF: Counts cells meeting condition

DATEDIF: Calculates difference between two dates

DAY: Extracts day from date serial number

Create common Excel errors

EOMONTH: Returns last day of month offset from date

Equality test

EXACT: Compares two text strings (case-sensitive)

FIND: Returns starting position of one text string within another (case-sensitive)

Zero-argument overload so degenerate formulas like =AND() still compile.

Flatten mixed arguments into a single array of cell values: scalars are appended, arrays are concatenated. Used by the code generator for functions that conceptually take a flat list of values but may receive any mix of cell references and ranges (AND, OR, CONCAT, IFS, MEDIAN, STDEV, ...). Mirrors the argument handling of the sum overloads.

FLOOR: Rounds number down to nearest multiple of significance

Greater than or equal

Greater than

HLOOKUP: Horizontal lookup

IF: Specifies a logical test to perform

IFS: Evaluates multiple conditions and returns value for first true condition

INDEX: Returns value from array at given position

INT: Rounds a number down to the nearest integer

Less than or equal

LEFT: Returns the specified number of characters from the start of a text string

LEN: Returns the number of characters in a text string

LOWER: Converts text to lowercase

Less than

MAX: Single array overload for backward compatibility

MAX: Multiple arguments (arrays and/or scalars mixed)

MAX: Multiple arrays only

MEDIAN: Returns the median of the given numbers

MID: Returns a specific number of characters from a text string starting at a specified position

MIN: Single array overload for backward compatibility

MIN: Multiple arguments (arrays and/or scalars mixed)

MIN: Multiple arrays only

MOD: Returns the remainder after division

MONTH: Extracts month from date serial number

Inequality test

NOT: Reverses the logic of its argument

NOW: Returns current date and time as serial number

OR: Returns TRUE if any argument is TRUE

POWER: Returns the result of a number raised to a power

PROPER: Capitalizes first letter of each word

RAND: Returns a random number between 0 and 1

RANDBETWEEN: Returns random integer between two numbers

REPT: Repeats text given number of times

RIGHT: Returns the specified number of characters from the end of a text string

ROUND: Rounds a number to a specified number of digits

ROUNDDOWN: Rounds number down toward zero

ROUNDUP: Rounds number up away from zero

SEARCH: Returns position of one text string within another (case-insensitive)

SQRT: Returns the square root of a number

STDEV.S: Estimates standard deviation based on a sample

STDEV.P: Calculates standard deviation based on entire population

SUBSTITUTE: Replaces existing text with new text

SUM: Single array overload for backward compatibility

SUM: Multiple arguments (arrays and/or scalars mixed)

SUM: Multiple arrays only

SUMIF: Sums cells meeting condition

SWITCH: Evaluates value against list and returns matching result

TEXT: Formats a number and converts to text

Helper to convert cell value to BigFloat

Helper to convert cell value to string

TODAY: Returns current date as serial number

TRIM: Removes spaces from text except for single spaces between words

UPPER: Converts text to uppercase

VALUE: Converts text to number

VAR.P: Calculates variance based on entire population

VAR.S: Estimates variance based on a sample

VLOOKUP: Vertical lookup

YEAR: Extracts year from date serial number

Excel's MIN/MAX of an empty set is 0, not an error.