Excel formula functions: Batch 1

[gunnsth]

Description

Based on #336 the task is to implement and create testcases for the following functions:

• CELL

• CHOOSE

• COLUMN

• COLUMNS

• COUNTIF

• COUNTIFS

• CLEAN

• VALUE

• ROW

• ROWS

• VLOOKUP (?)

• LOOKUP

• INDEX

• MATCH

• MAXA

• MAXIFS

• MINA

• MINIFS

• LARGE

• LOWER

• SMALL

• IFS

• OFFSET

• ISBLANK

• ISNONTEXT

• ISNUMBER

• ISTEXT

• ISODD

• ISERR

• ISERROR

• ISEVEN

• ISFORMULA

• ISLEAPYEAR

• ISLOGICAL

• ISNA

• ISREF

• FIND

• FINDB

• SEARCH

• SEARCHB

• SUMIF

• SUMIFS

• CONCAT

• CONCATENATE

• REPLACE

• TEXT

• TEXTJOIN

• YEAR

• YEARFRAC

• NOW

• TODAY

• TIME

• TIMEVALUE

• DATETIME

• DATE

• DATEDIF

• DATEVALUE

• DAY

• DAYS

• MDURATION

• MONTH

• MINUTE

• EDATE

• EOMONTH

• PDURATION

Expected Behavior

Expect the functions to work on Excel spreadsheets and testcases to work.

Actual Behavior

N/A

[zgordan-vv]

Some functions from list are discovered as already working (I just couldn't make them work when tested):

CLEAN
VLOOKUP

Will add more if discover

[zgordan-vv]

DAYSINMONTH, YEARS, ISEVEN_ADD, ISODD_ADD, MONTHS are only Open/Libre functions, so I suppose we can remove them from the list

[zgordan-vv]

DATEVALUE is already done and merged into master, MDURATION and PDURATION are done in #353

[gunnsth]

This batch has been completed.