quadratic
quadratic copied to clipboard
Formulas implementation tracking list
Roughly in priority order. Feel free to comment if you want to see additional formulas or have different priorities.
- [x] SUM
- [x] AVERAGE
- [x] IF
- [x] SUMIF #492
- [x] COUNT
- [x] COUNTIF #492
- [x] COUNTBLANK #492
- [x] MIN/MAX
- [x] CONCATENATE
- [x] VLOOKUP/HLOOKUP
- [x] MATCH #1540
- [x] INDEX #1555
- [x] CEILING/FLOOR #1537
- [x] CEILING.MATH/FLOOR.MATH #1537
- [x] INT/MOD #1537
- [x] SUMIFS #1630
- [x] COUNTIFS #1630
- [x] IFERROR #1640
- [x] LEN #1655
- [x] POWER, EXP, LOG10, LOG, LN #1707
- [x] TRIM #1709
- [x] UNIQUE #1742
- [x] SORT #1742
- [x] FILTER #1742
- [x] LEN #1655
- [x] LEFT/RIGHT/MID #1709
- [x] UPPER, LOWER, PROPER #1709
- [x] NOW, TODAY, TIME, HOUR, MINUTE, SECOND #1933
- [ ] EDATE #2166
- [ ] SUMPRODUCT #2189
- [ ] EOMONTH #2166
- [ ] ROW
- [ ] PMT #2154
- [ ] PV
- [ ] NPV
- [ ] IRR, XIRR
- [ ] FV
- [ ] IFNA #2168
- [ ] TEXT @HactarCE
- [ ] VALUE
- [ ] MEDIAN
- [ ] MODE
- [ ] FIND
- [x] ROUND #2176
- [ ] ROUNDUP #2176
- [ ] ROUNDDOWN #2176
- [ ] MROUND @HactarCE
- [ ] COLUMN
- [ ] REPLACE
- [ ] SUBSTITUTE
- [ ] STDEV #2154
- [ ] RATE
- [ ] NPER
- [ ] OFFSET
- [ ] VAR #2154
- [ ] COVAR
- [ ] DATEDIF
- [ ] CORR
- [ ] TRUNC #2176
- [ ] ~~FRAC~~ doesn't exist
- [ ] RANK
- [ ] IPMT
- [ ] PPMT
- [ ] SLN
- [ ] DB
- [ ] DDB
- [ ] AVERAGEIFS
- [ ] DATEVALUE
Delaying date- & time-related functions for sometime in the future