SYSTEM AND METHOD FOR A SPREADSHEET APPLICATION SUPPORTING DIVERSE FORMULAIC FUNCTIONS

摘要

A spreadsheet application or other application supporting formulaic cells that automatically provides support for a number of diverse formulaic functions. The automatically provided diverse formulaic functions include a function returning the value of the formula logic if the logic can be evaluated without an error. Another function finds a value in a formulaic cell that is in the same row as a particular value from the first column and the same column as a particular value in the first row. Other functions allow a selection of a set of multiple lookup rows and columns for matching the values used as variables in the function. The spreadsheet application is further configured to automatically supply other functions in addition to those described.

主权项

1. A computer-readable medium that includes a spreadsheet application for providing a diverse set of functions within a spreadsheet document, comprising:
instantiating the spreadsheet document by launching the spreadsheet application on a computing device, wherein the spreadsheet document includes a formulaic cell; and automatically supporting entry of at least one of a set of diverse functions in the formulaic cell such that a result is obtained in response to processing the entered function, the set of diverse functions comprising: an IFERROR function, a NONERROR function, a TABLELOOKUP function, an HLOOKUPMULTIPLE function, a VLOOKUPMULTIPLE function, a WORD function, a WORDCOUNT function, a CONCATENATERANGE function, a DATEDIFFERENCE function, a DATEADD function, a WEEKNUMISO function, an AVERAGEIF function, an AVERAGEIFS function, a SUMIFS function, a COUNTIFS function, a WEIGHTEDAVERAGE function, a COUNTDISTINCT function, a SORTRANGE function, a DISTINCT function, and a FILTER function.