Category Archives: Excel

Excel FISHER Function in Apex Salesforce

By | August 21, 2017

In this post we will see how we can write Excel FISHER function in Apex Salesforce. Before going to the apex code lets first see some details about FISHER function. This function returns the fisher transformation at x. Syntax of FISHER function is as follows in Excel FISHER(x) WHERE x is required Value of x should be… Read More »

Excel CORREL function in Apex Salesforce

By | August 14, 2017

Today we will see salesforce apex equivalent code for Excel CORREL function. Excel CORREL function in Apex Salesforce can be used if we need to perform same calculation on salesforce data as excel CORREL  function. Syntax of CORREL function is as follows in Excel CORREL(array1, array2) WHERE array1 and array2 both are Required. We must ensure that array1 and array2… Read More »

Excel INTERCEPT function in Apex Salesforce

By | August 7, 2017

Hello awesome Developers!!! This post will save your time if you are going to implement Excel INTERCEPT function in apex salesforce. In my previous post of excel function (Excel LINEST function in Apex Salesforce), we coded for LINEST function of excel. Before we jump to code, lets have a quick view of INTERCEPT function. Syntax of Intercept… Read More »

Excel LINEST function in Apex Salesforce

By | July 7, 2017

As a developer we sometime need to implement excel function in code for meeting client’s requirement. Here I will share code for Excel LINEST function in apex. You can check LINEST function/method of excel here. See below code method, you can use it in your apex class.

It will save your time if you… Read More »