by Ilker | Aug 20, 2019 | Excel Formulas
The Excel PRICE function is a Financial formula that calculates and returns the price per $100 face value of a security that pays periodic interest. In this guide, we’re going to show you how to use the PRICE function and also go over some tips and error handling...
by Ilker | Aug 8, 2019 | Excel Formulas
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...
by Ilker | Aug 8, 2019 | Excel Formulas
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...
by Ilker | Jul 29, 2019 | Excel Formulas
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...
by Ilker | Jul 29, 2019 | Excel Formulas
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...
by Ilker | Jul 22, 2019 | Excel Formulas
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...
by Ilker | Jul 22, 2019 | Excel Formulas
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....
by Ilker | Jul 17, 2019 | Excel Formulas
The Excel ENCODEURL function is a Web formula that can convert strings into their URL-encoded versions. The ENCODEURL function is available for 2013 and later versions of Excel on the Windows platform. In this guide, we’re going to show you how to use the Excel...
by Ilker | Jul 17, 2019 | Excel Formulas
The FILTERXML function is a Web formula that can return specific data from an XML content, using a given XPath. This ability makes the function suitable for use in conjunction with the WEBSERVICE function. The FILTERXML function is available for 2013 and later...
