Tag Archives: Excel method

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 »