US Patent:
20060161844, Jul 20, 2006
Inventors:
Roy Simkhay - Seattle WA, US
Charles Ellis - Seattle WA, US
Alexander Babanov - Redmond WA, US
David Gainer - Redmond WA, US
Daniel Cory - Seattle WA, US
Matthew Androski - Bellevue WA, US
Andrew Becker - Bellevue WA, US
Jeremy Pankratz - Fall City WA, US
Monica McAmis - Renton WA, US
Simon Jones - Cambridge, GB
Assignee:
Microsoft Corporation - Redmond WA
International Classification:
G06F 17/00
Abstract:
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.