Excel Tricks with Tejraj

In this blog post we will learn to about RAND function in excel. RAND Function will return random numbers which are greater than or equal to zero and less than one. Where to find RAND function on Excel Screen: RAND function can be found under “Math & Trig” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Math & Trig” function category, we can see list of various Math & Trig functions available in excel. RAND function is highlighted in blue in below image. Once we click on RAND option as highlighted above, we will get the function argument dialog box as shown in below image. Syntax of RAND Function: The Syntax of RAND function is as below: =RAND() Arguments of RAND Function: RAND function does not take any argument. Important Points about RAND Function: 1. RAND function does not take any argument 2. Output of RAND function changes once excel sheet gets recalculated (either by automatic or manual recalculatio...

In this blog post we will learn about INT function in excel. INT Function will round a number down to nearest integer. Where to find INT function on Excel Screen: INT function can be found under “Math & Trig” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Math & Trig” function category, we can see list of various Math & Trig functions available in excel. INT function is highlighted in blue in below image. Once we click on INT option as highlighted above, we will get the function argument dialog box as shown in below image. Syntax of INT Function: The Syntax of INT function is as below: =INT(number) Arguments of INT Function: INT function takes only one argument which is mandatory. number : This is the real number which you want to round down to an integer Example of INT Function: We have listed few random numbers in column A. With the help of INT function, we will round down these number to an integer. Fo...

In this blog post we will learn to about POWER function in excel. Whenever we want to return value of a number raised to its power then we can use POWER function which is readily available in excel. What is POWER of a number? In mathematics, POWER of a number means how many times a number we want to use in multiplication. For example, 5^2 (5 to the power of 2) means 5 is used twice in multiplication (5x5 = 25). 2^3 (2 to the power of 3) means 2 is used three times in multiplication (2x2x2 = 8). Where to find POWER function on Excel Screen: POWER function can be found under “Math & Trig” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Math & Trig” function category, we can see list of various Math & Trig functions available in excel. POWER function is highlighted in blue in below image. Once we click on POWER option as highlighted above, we will get the function argument dialog box as shown in below image. ...

In this blog post we will learn to about FACT function in excel. Whenever we want to return factorial of a number, we can use FACT function which is readily available in excel. What is Factorial of number? In mathematics, factorial of a number is calculated by multiplying all the numbers which are less than the provided number. For example, if we want to calculate factorial of 5 then it will be 5x4x3x2x1 = 120. i.e., factorial of 5 is 120. Where to find FACT function on Excel Screen: FACT function can be found under “Math & Trig” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Math & Trig” function category, we can see list of various Math & Trig functions available in excel. FACT function is highlighted in blue in below image. Once we click on FACT option as highlighted above, we will get the function argument dialog box as shown in below image. Syntax of FACT Function: The Syntax of FACT function is as b...