Excel FALSE Function

Excel FALSE Function

The Excel FALSE function is a Logical formula that essentially returns the logical value FALSE. Microsoft says that the FALSE is kept in Excel for the sake of compatibility with other spreadsheet programs. You do not need to use in most cases, except for when using...
TRUE Function in Excel

TRUE Function in Excel

The Excel TRUE function is a Logical formula that essentially returns the logical value TRUE. Microsoft notes that the TRUE function is included in Excel for compatibility with other spreadsheet programs. You do not need to use in most cases, except for when using...
How to print headings in Excel

How to print headings in Excel

The headings in Excel are essentially the screen guides that make working with cells or ranges easier. By default, row and column headings in Excel don’t show in printed documents. If you want to print them anyways, Excel has an option which allows including row...
How to print gridlines in Excel

How to print gridlines in Excel

The grid structure is an important feature that helps distinguish between sections, and build an interface easily when using spreadsheets. They are the guide in this structure that makes each cell distinct from other. If you want the gridlines that appear on...
Function: ERF.PRECISE

Function: ERF.PRECISE

The Excel ERF.PRECISE (ERF PRECISE) function is an Engineering formula that calculates and returns the error function, integrated between a limit and zero (0). This function has been introduced Excel 2010, and is not available in earlier versions. However, the...
Function: ERFC.PRECISE

Function: ERFC.PRECISE

The Excel ERFC.PRECISE (ERFC PRECISE) function is an Engineering formula that calculates and returns the complementary error function, integrated between a specified lower limit and infinity. This function has been introduced Excel 2010, and is not available in...
Function: ERFC

Function: ERFC

The ERFC function is an Engineering formula that calculates and returns the complementary error function, integrated between a lower limit and infinity. This formula essentially a subset of the error functions that calculate the probability of a value falling into a...
Function: ERF

Function: ERF

The ERF function is an Engineering formula that calculates and returns the error function, integrated between specified lower and upper limits. In this guide, we’re going to show you how to use the ERF function, and also go over some tips and error handling methods....