System and method for a spreadsheet application supporting diverse formulaic functions

A computer system, comprising:

• a processing unit;
• and
• a computer storage device storing instructions that, when executed by the processing unit, cause the processing unit to perform operations comprising:
• in a spreadsheet application, automatically supporting a function in a formulaic cell, wherein the function is a non-nested function that is automatically provided by the spreadsheet application;
• and
• allowing a user to select the function from a plurality of functions including at least:
• an if-error function comprising a first parameter that specifies an error return value and a second parameter that specifies an error type, wherein:
• the if-error function evaluates a formula in the formulaic cell and displays the specified error return value within the formulaic cell when the evaluated formula returns an error matching the specified error type;
• and
• the if-error function displays the evaluated formula within the formulaic cell when the evaluated formula does not return an error.

A computer-implemented method, comprising:

• in a spreadsheet application, automatically supporting a function in a formulaic cell, wherein the function is a non-nested function that is automatically provided by the spreadsheet application;
• and
• allowing a user to select the function from a plurality of functions including at least:
• an iferror function having a first parameter specifying a formula to be evaluated and a second parameter specifying an error value, wherein the iferror function is configured to display a return value in the formulaic cell by performing the following:
• in response to the evaluated formula not returning an error, determining the return value to be the value of the evaluated formula;
• and
• in response to the evaluated formula returning an error of a type selected from a group of error types consisting of #NULL!, #DIV/0!, #VALUE!, #REF!, #NAME?, #NUM!, and #N/A, determining the return value to be the error value.