Build formulas step-by-step with real-time syntax checking and platform compatibility verification.
操作の種類 / 関数分類 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.
