Excel-Function

How to use Excel SUMSQ Function to get Sum of the Squares

Excel SUMSQ function is another important function which is used to returns the sum of the squares of the given arguments. The Excel SUMSQ function is built-in very popular function. This function is also used as a worksheet function in active Excel sheet. In this article we have to explain how to effectively use SUMSQ function in Excel. Read More

How to use Excel Subtotal Function

Excel Subtotal function allows you to returns a subtotal in the list or database. Subtotal function in Excel return the Sum, Average, Count, Max, Min and many more. Excel Subtotal function is located in Math and Trig category. You can also use this function as a worksheet function in Excel. Read More

Excel FactDouble Function – Return Double Factorial of Number

Excel FactDouble function is used to returns the double factorial of given positive number. The FactDouble function in Excel is located in the Math & Trig category. The double factorial of any positive number is equal to 6*4*2…. number, while for any negative number is equal to 5*3*1.. If you need to quickly calculate double factorial of any large even or odd number then you can use Excel FactDouble function in active worksheet. In this article we have to describe the formula and how to use Excel FactDouble function. Read More

Excel Fact Function – Return Factorial of Number

Excel Fact function is used to returns the factorial of given positive number. The Fact function in Excel is located in the Math & Trig category. The factorial of a positive number is equal to 1*2*3*…. number. If you need to quickly calculate factorial of any large number then you can use Excel Fact function in active worksheet. In this article we have to describe the formula and how to use Excel Fact function. Read More

How to use Excel INT Function to Remove Decimal Places

Excel INT function which is used to rounds a number down to the nearest integer. The Excel INT function is located in the Math & Trig category in Excel. If you have a large list of numbers in which you have lot of decimal places then you have easily remove then with the help of INF function in Excel. Read More

How to use Excel RAND Function

RAND is an important function which is found in Math & Trig category of Microsoft Excel. The Excel RAND function allows you to quickly returns a random number between the 0 and 1 value. With the help of RAND Function you will get a random number which is greater than or equal to 0 and less than to 1, evenly distributed (changes on recalculation). Read More

How to use the RANDBETWEEN Function in Excel

The Excel RANDBETWEEN function is very popular function which is located in Math & Trig category. Microsoft Excel RANDBETWEEN function is used to returns a random number between the number you specify. This function returns a random number which is between a bottom and top range. The RANDBETWEEN function in Excel returns a unique random number every time when your spreadsheet recalculates with the help of F9 key. Read More

Easy Way to Use OFFSet Function in Excel

OFFSet is an important function of Excel OFFSet function in Excel allows you to quickly return a reference of a given range which is offset from the starting cell or range of cells which is specified by number of rows and columns. There are lot of inbuilt functions which is rarely used by different Excel users. But if you have better command on these functions then you can easily resolve different problems and make yourself as Excel expert. Read More