Quickly search common Excel formulas and usage examples.
The exported CSV includes a UTF-8 BOM, so Excel opens Chinese text correctly.
| Item | Formula | Source / Standard |
|---|---|---|
| Absolute reference | dollar A dollar 1 locks row and column | ISO/IEC 29500 spreadsheet formula reference |
| Conditional sum | SUMIF(range, criteria, sum_range) | ISO/IEC 29500 spreadsheet functions |
| Vertical lookup | VLOOKUP(key, table, col, FALSE) | ISO/IEC 29500 spreadsheet functions |