# Extract Microsoft Excel Formulas

Normally, the actual value of a formula is extracted from an Excel spreadsheet; the formula from which the value is derived is not included in the output. However, KeyView enables you to include the value as well as the formula in the output. For example, if Filter is configured to extract the formula and the formula value, the output might look like this:

    245 = SUM(B21:B26)

The calculated value from the cell is `245` and the formula from which the value is derived is `SUM(B21:B26)`.

NOTE: Depending on the complexity of the formulas, enabling formula extraction might result in slightly slower performance.

To set the extraction option for formulas, add the following lines to the `formats.ini` file:

    [Options]
    getformulastring=option

where `option` is one of the following:

Option | Description
--- | ---
`0` | Extract the formula value only. This is the default. If formula extraction is enabled, and you want to return to the default, set this option.
`1` | Extract the formula only.
`2` | Extract the formula and the formula value.

If a function in a formula is not supported or is invalid, and option 1 or 2 is specified, only the calculated value is extracted. See Supported Microsoft Excel Functions for a list of supported functions.

When formula extraction is enabled, Filter can extract Microsoft Excel formulas that contain the functions listed in the following table.

Supported Microsoft Excel Functions

`=ABS()` | `=ACOS()` | `=AND()` | `=AREAS()`
`=ASIN()` | `=ATAN2()` | `=ATAN2()` | `=AVERAGE()`
`=CELL()` | `=CHAR()` | `=CHOOSE()` | `=CLEAN()`
`=CODE()` | `=COLUMN()` | `=COLUMNS()` | `=CONCATENATE()`
`=COS()` | `=COUNT()` | `=COUNTA()` | `=DATE()`
`=DATEVALUE()` | `=DAVERAGE()` | `=DAY()` | `=DCOUNT()`
`=DDB()` | `=DMAX()` | `=DMIN()` | `=DOLLAR()`
`=DSTDEV()` | `=DSUM()` | `=DVAR()` | `=EXACT()`
`=EXP()` | `=FACT()` | `=FALSE()` | `=FIND()`
`=FIXED()` | `=FV()` | `=GROWTH()` | `=HLOOKUP()`
`=HOUR()` | `=ISBLANK()` | `=IF()` | `=INDEX()`
`=INDIRECT()` | `=INT()` | `=IPMT()` | `=IRR()`
`=ISERR()` | `=ISERROR()` | `=ISNA()` | `=ISNUMBER()`
`=ISREF()` | `=ISTEXT()` | `=LEFT()` | `=LEN()`
`=LINEST()` | `=LN()` | `=LOG()` | `=LOG10()`
`=LOGEST()` | `=LOOKUP()` | `=LOWER()` | `=MATCH()`
`=MAX()` | `=MDETERM()` | `=MID()` | `=MIN()`
`=MINUTE()` | `=MINVERSE()` | `=MIRR()` | `=MMULT()`
`=MOD()` | `=MONTH()` | `=N()` | `=NA()`
`=NOT()` | `=NOW()` | `=NPER()` | `=NPV()`
`=OFFSET()` | `=OR()` | `=PI()` | `=PMT()`
`=PPMT()` | `=PRODUCT()` | `=PROPER()` | `=PV()`
`=RATE()` | `=REPLACE()` | `=REPT()` | `=RIGHT()`
`=ROUND()` | `=ROUND()` | `=ROW()` | `=ROWS()`
`=SEARCH()` | `=SECOND()` | `=SIGN()` | `=SIN()`
`=SLN()` | `=SQRT()` | `=STDEV()` | `=SUBSTITUTE()`
`=SUM()` | `=SYD()` | `=T()` | `=TAN()`
`=TEXT()` | `=TIME()` | `=TIMEVALUE()` | `=TODAY()`
`=TRANSPOSE()` | `=TREND()` | `=TRIM()` | `=TRUE()`
`=TYPE()` | `=UPPER()` | `=VALUE()` | `=VAR()`
`=VLOOKUP()` | `=WEEKDAY()` | `=YEAR()` |

© Copyright 2016-2019 Micro Focus or one of its affiliates | Send documentation feedback Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a mail client, and then send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm