Build formulas step-by-step with real-time syntax checking and platform compatibility verification.
Operation Type SUM โ Total a range ADD (+) โ Cell A plus Cell B SUBTRACT (-) โ Cell A minus Cell B MULTIPLY (*) โ Cell A times Cell B DIVIDE (/) โ Cell A divided by Cell B PERCENT (%) โ Cell A as % of Cell B ABS โ Absolute value SQRT โ Square root POWER โ Exponent (power of 2) MOD โ Remainder of division INT โ Round down to integer PRODUCT โ Multiply range SUMPRODUCT โ Sum of products AVERAGE โ Mean of range MEDIAN โ Middle value of range MIN โ Smallest value in range MAX โ Largest value in range MINA โ Min including text/logicals MAXA โ Max including text/logicals STDEV โ Standard deviation (sample) STDEVP โ Standard deviation (population) VAR โ Variance (sample) VARP โ Variance (population) COUNT โ Count numbers in range COUNTA โ Count non-empty cells COUNTBLANK โ Count empty cells LARGE โ Nth largest value SMALL โ Nth smallest value RANK โ Rank a value in a range PERCENTILE โ Nth percentile QUARTILE โ Quartile value (0-4) CORREL โ Correlation coefficient FORECAST โ Linear forecast IF โ Test single condition IFS โ Test multiple conditions SWITCH โ Match value to results AND โ All conditions must be TRUE OR โ At least one condition TRUE NOT โ Reverse logical value XOR โ Exclusive OR (one TRUE) IFERROR โ Fallback for any error IFNA โ Fallback for #N/A error UPPER โ Convert text to uppercase LOWER โ Convert text to lowercase PROPER โ Convert text to Title Case TRIM โ Remove extra spaces CLEAN โ Remove non-printable chars LEN โ Get character length LEFT โ Extract start characters RIGHT โ Extract end characters MID โ Extract middle characters REPT โ Repeat text N times EXACT โ Case-sensitive text comparison VALUE โ Convert text number to number TEXT โ Format number as text TEXTJOIN โ Join range with delimiter CONCAT โ Combine text strings SUBSTITUTE โ Replace matching text REPLACE โ Replace characters by position FIND โ Find text (case sensitive) SEARCH โ Find text (case insensitive) CHAR โ Get character by ASCII code CODE โ Get ASCII code of character NETWORKDAYS โ Calculate working days NETWORKDAYS.INTL โ Custom weekend WORKDAY โ Calculate target work day DATEDIF (Days) โ Days difference DATEDIF (Months) โ Months difference DATEDIF (Years) โ Years difference DATEDIF (MD) โ Days difference ignoring months DAYS โ Total calendar days diff TODAY โ Today's current date NOW โ Current date & time EDATE โ Add/subtract months to date EOMONTH โ End of month calculation DAY โ Get day of month (1-31) MONTH โ Get month number (1-12) YEAR โ Get 4-digit year HOUR โ Get hour of day (0-23) MINUTE โ Get minute (0-59) SECOND โ Get second (0-59) WEEKDAY โ Get weekday index (1-7) WEEKNUM โ Get week of year (1-54) DATE โ Build date from Year/Month/Day XLOOKUP โ Modern exact search INDEX + MATCH โ Legacy search VLOOKUP โ Vertical column search HLOOKUP โ Horizontal row search CHOOSE โ Select value by index SUMIFS โ Sum range with criteria AVERAGEIFS โ Average with criteria COUNTIFS โ Count cells with criteria FILTER โ Extract rows matching criteria UNIQUE (Filter) โ Get unique items SEQUENCE โ Generate sequential array SORT โ Sort range by column SORTBY โ Sort range by external array UNIQUE (Sort) โ Get unique sorted items ROUND โ Round to decimal places ROUNDUP โ Round up to decimals ROUNDDOWN โ Round down to decimals CEILING โ Round up to nearest multiple FLOOR โ Round down to nearest multiple MROUND โ Round to nearest multiple TRUNC โ Truncate decimal digits PMT โ Loan periodic payment amount FV โ Future value of investment PV โ Present value of investment NPV โ Net present value of cash flows IRR โ Internal rate of return RATE โ Interest rate per period NPER โ Number of payment periods IPMT โ Interest portion of payment PPMT โ Principal portion of payment SLN โ Straight line depreciation OFFSET โ Shift range reference offset INDIRECT โ Reference cell via text address ADDRESS โ Create cell address text TRANSPOSE โ Transpose rows/columns ROW โ Row number of a cell COLUMN โ Column number of a cell ROWS โ Count number of rows in range COLUMNS โ Count number of columns in range
Operation SUM โ Total a range ADD โ Two cells together SUBTRACT โ Difference MULTIPLY โ Product DIVIDE โ Quotient (safe) PERCENT โ Proportion of total ABS โ Absolute value SQRT โ Square root POWER โ Exponent MOD โ Remainder INT โ Integer part (floor) PRODUCT โ Multiply all values SUMPRODUCT โ Sum of products
Each condition is tested in order; first TRUE wins.
Logical Function AND โ All conditions must be TRUE OR โ At least one condition TRUE NOT โ Negate a condition XOR โ Exactly one TRUE
Date Operation NETWORKDAYS โ Working days NETWORKDAYS.INTL โ Custom weekend WORKDAY โ Future working day DATEDIF (Days) DATEDIF (Months) DATEDIF (Years) DATEDIF (Days ignoring months) DAYS โ Simple day count TODAY โ Today's date NOW โ Current date & time EDATE โ Add months EOMONTH โ End of month
Function FILTER โ Extract rows matching condition UNIQUE โ Remove duplicates SEQUENCE โ Generate number series
Function SORT โ Sort a range SORTBY โ Sort by another column UNIQUE โ Remove duplicates
Function PMT โ Loan monthly payment FV โ Future value of investment PV โ Present value NPV โ Net present value IRR โ Internal rate of return RATE โ Interest rate per period NPER โ Number of payment periods IPMT โ Interest portion of payment PPMT โ Principal portion of payment SLN โ Straight-line depreciation
Select a type above to preview.
