Built-in functions required for the initial release

[wojciechczerniak]

Description

Those functions are REQUIRED for the initial release in January.

Funtions list

✓	Function Name	Funtion Type*	✓	Function Name	Funtion Type*
✓	DATE	DATE	✓	DAY	DATE
✓	DAYS	DATE	✓	ACOS	M
✓	ASIN	M	✓	ATAN	M
✓	COS	M	✓	COT	M
✓	E	M	✓	ERF	M
✓	ERFC	M	✓	LN	M
✓	LOG	M	✓	LOG10	M
✓	PI	M	✓	POWER	M
✓	SIN	M	✓	SQRT	M
✓	TAN	M	✓	ABS	Q
✓	AND	Q	✓	AVERAGE	Q
✓	AVERAGEA	Q	✓	AVERAGEIF	Q
✓	BASE	Q	✓	BIN2DEC	Q
✓	BIN2HEX	Q	✓	BIN2OCT	Q
✓	BITAND	Q	✓	BITLSHIFT	Q
✓	BITOR	Q	✓	BITRSHIFT	Q
✓	BITXOR	Q	✓	CEILING	Q
✓	CHAR	Q	✓	CODE	Q
✓	CONCATENATE	Q	✓	CORREL	Q
✓	COUNTBLANK	Q	✓	COUNTA	Q
✓	COUNTIFS	Q	✓	COUNTUNIQUE	Q
✓	COUNTIF	Q
✓	DEC2BIN	Q	✓	DEC2HEX	Q
✓	DEC2OCT	Q	✓	DECIMAL	Q
✓	DEGREES	Q	✓	DELTA	Q
✓	EVEN	Q	✓	IF	Q
✓	INT	Q	✓	ISEVEN	Q
✓	ISODD	Q	✓	MAX	Q
✓	MAXA	Q	✓	MEDIAN	Q
✓	MIN	Q	✓	MINA	Q
✓	MOD	Q	✓	NOT	Q
✓	ODD	Q	✓	OR	Q
✓	ROUND	Q	✓	ROUNDDOWN	Q
✓	ROUNDUP	Q	✓	SPLIT	Q
✓	SUM	Q	✓	SUMIF	Q
✓	SUMIFS	Q	✓	SUMPRODUCT	Q
✓	SUMSQ	Q	✓	TRUNC	Q
✓	XOR	Q	✓	TRUE	Q
✓	FALSE	Q

Total: 77

Function Types:

• Q - basic
• M - mathematics
• STAT - statistics
• FIN - finance
• DATE - date and time

Reference

Appendix 5

[swistak35]

Were already added before: TRUE, FALSE, IF, AND, OR, COUNTUNIQUE, DATE, MEDIAN, SUM, MAX, MIN, COUNTBLANK, SUMIF, SUMIFS, SUMPRODUCT, CONCATENATE, SPLIT, ACOS.

Added today: SUMSQ, NOT, ISEVEN, ISODD, ROUNDUP, ROUNDDOWN, ROUND, TRUNC, INT.

When it comes to ROUNDDOWN and TRUNC -- I couldn't spot behaviour difference between these two. If you find some example, please create the issue :)

[voodoo11]

Added today: DEC2BIN, DEC2OCT, DEC2HEX, BIN2DEC, BIN2OCT, BIN2HEX

[swistak35]

Done: ASIN, COS, SIN, TAN, ATAN, COT, MINA, MAXA, EVEN, ODD

[swistak35]

Done: LOG10, LN, LOG, XOR

[aninde]

I compared the list with the list of requirements and one function was missing: COUNIF. I added it.

There is no AAA function on the list of requirements.

[wojciechczerniak]

Oh right.... it was a filler for copy and paste to create the table 😅 Fixed

[voodoo11]

Added: BITAND, BITOR, BITXOR, BITLSHIFT, BITRSHIFT.

[voodoo11]

Done: POWER, SQRT, MOD, DECIMAL BASE, DAY, DAYS

[voodoo11]

Done: CEILING, CODE, CHAR, DELTA

[voodoo11]

Done: ERF, ERFC

[swistak35]

Done: AVERAGE, AVERAGEA, AVERAGEIF, COUNTA, COUNTIF, COUNTIFS, SUMIFS, DEGREES, ABS

[swistak35]

Done: CORREL.

PI was already done but not reported.

[swistak35]

Done: E.

It looks that all are done :)

[wojciechczerniak]

Nicely done! You can test all of them @aninde