Category: Excel Function

The DATEDIF function is to count the number of days, months, or years between two dates. Formula: =DATEDIF(start_date,end_date,unit) Explanations: – The start_date is required, which is the first date …

The DATE function is to combine the year, the month and the day to form a date. Formula: =DATE(year,month,day) Explanations: – Year is required, an integer with one to …

The TRUNC function is to return the exact number with the digits you specified. Formula: =TRUNC(number, ) Explanations: – The number is required, which is the number to truncate. …

The TANH function returns the hyperbolic tangent of a number. Formula: =TANH(number) Explanations: The number is required, any real number that you want to find the hyperbolic tangent. Download: …

The tangent of an angle is the ratio of the length of the opposite side to the length of the adjacent side. In excel, TAN function returns the tangent …

The SUMXMY2 function returns the sum of the squares of the differences in two arrays. Formula: =SUMXMY2(array_x, array_y) Explanations: 1. Array_x is required which is the first data array. …