quadratic icon indicating copy to clipboard operation
quadratic copied to clipboard

Formulas implementation tracking list

Open davidkircos opened this issue 2 years ago • 9 comments

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

davidkircos avatar Mar 03 '23 21:03 davidkircos

Delaying date- & time-related functions for sometime in the future

HactarCE avatar Mar 03 '23 22:03 HactarCE