Here is the list of excel forumlas along with their function.
ABS : ABS function is used to Return the absolute value of a supplied number. Absolute value means the modulus of the number we supplied.
SIGN : Sign formula is used to returns the sign of a supplied number. Sign of the number can be +1, -1 or 0.
GCD : GCD function is used to return the greatest Common Divisor or GCD of two or more given numbers.
LCM : Want to find the lowest common multiple of two numbers? This formula or function make it much easy. It returns the Least Common Multiple of two or more given numbers.
SUM : This formula can be used to return the sum of 2 or complete list of numbers. This is quite useful formula when you need to add individual entries of a column or row.
PRODUCT : Want to find the product of 2 numbers or product of elements of entire row or column then this is the perfect solution to cut short your time. It returns the product of the given numbers.
List of Advanced Excel Formulas
POWER : Power formula or function is used to find the result of a number raised to a given power. It returns the result of a given number raised to a power. It greatly reduces your time by going certain high power calculations in seconds.
SQRT : While preparing a balance sheet or a project in excel many times we need to find the square root of the elements. Now finding square root is made much easier. Just use sqrt forumla and it returns the positive square root of the given number.
QUOTIENT : This formula can be used to return the integer portion of a division between two given numbers. You don’t need to calculate quotient manually anymore.
MOD : When we divide a number by another number and we want to know the remainder then this is the perfect formula for that thing. It will return the remainder from a division between two numbers.
AGGREGATE : This is quite useful function as it has the ability to perform more than 1 function. It can be used to calculate the sum, product, average and much more for a list or even a database. It also has the option to ignore hidden rows and error values. This feature is available in only in Excel 2010. Previous versions of excel don’t support above feature.
SUBTOTAL : This formula is used to performs a specified calculation like sum, product, average, etc. for the values which we supply.
CEILING : Ceiling function is used for rounding off a number away from zero. Rounding off away from zero means rounding a positive number up and a negative number down.
EVEN : This function is similar to ceiling function but it round off a number to next even number. It rounds a number away from zero that is rounds a positive number up and a negative number down to the next even number.
FLOOR : This formula is just opposite of ceiling function. It is sued to round of a number towards zero which means it rounds off a positive number down and a negative number up.
ODD : This function is similar to ceiling function but it round off a number to next odd number. It rounds a number away from zero that is rounds a positive number up and a negative number down to the next odd number.
ROUND : This function of formula is used to Round off a number up or down to a given number of digits.
TRUNC : This formula or function is used to truncate a number towards zero. It rounds off a positive number down and a negative number up to the next integer.
SUMIF : Sumif is a conditional sum formula in which sum is calculated if the condition or criteria is satisfied. It is used to add the cells in a supplied range for a given criteria.
SERIESSUM : This formula is used to find and returns the sum of a power series.
PI : This is quite handy formula used to returns the constant value of pi.
SQRTPI : this formula or function calculate the square root of a number and then multiply the result by pi and return the final result.
DEGREES : Degrees formula is a trigonometric formula used to convert Radians to Degrees.
RADIANS : This formula is a trigonometric formula used to convert Degrees to Radians.
COS : This trigonometric formula or function is used to returns the Cosine of a given angle.
ACOS : This formula or function is used to returns the Arccosine of a number.
COSH : This formula or function is used to returns the hyperbolic cosine of a number.
ACOSH : This formula or function is used to returns the inverse hyperbolic cosine of a number.
SIN : This trigonometric formula or function is used to return the Sine of a given angle.
ASIN : This trigonometric formula or function is used to return the Arcsine of a number.
SINH : This formula or function is used to return the Hyperbolic Sine of a number.
ASINH : This formula or function is used to return the Inverse Hyperbolic Sine of a number.
TAN : This trigonometric formula or function is used to return the Tangent of a given angle.
ATAN : This trigonometric formula or function is used to return the Arctangent of a given number
ATAN2 : This trigonometric formula or function is used to return the Arctangent of a given pair of x and y coordinates.
TANH : This trigonometric formula or function is used to return the Hyperbolic Tangent of a given number.
ATANH : This formula or function is used to return the Inverse Hyperbolic Tangent of a given number.
How to use excel formulas
These were the list of excel formulas now lets see how can we use these functions or formulas.
ABS : To use Abs formula just write =(equal to) ABS followed by the number in brackets as shown in the figure. As soon as you close the brackets and hit enter the absolute value of the number is calculated and displayed in the same cell as shown in the figure.
SUM : To use Sum formula just write =(equal to) SUM followed by the numbers in brackets as shown in the figure. As soon as you close the brackets and hit enter the sum of the numbers is calculated and displayed in the same cell as shown in the figure.
PRODUCT : To use Product formula just write =(equal to) PRODUCT followed by the numbers in brackets as shown in the figure. As soon as you close the brackets and hit enter the product of the numbers is calculated and displayed in the same cell as shown in the figure.
LCM : To use LCM formula just write =(equal to) LCM followed by the numbers in brackets as shown in the figure. As soon as you close the brackets and hit enter the LCM of the numbers is calculated and displayed in the same cell as shown in the figure.
CEILING : To use Ceiling formula just write =(equal to) CEILING followed by the number in brackets as shown in the figure. As soon as you close the brackets and hit enter the Round off of the number is evaluated and displayed in the same cell as shown in the figure.
FLOOR : To use Floor formula just write =(equal to) FLOOR followed by the number in brackets as shown in the figure. As soon as you close the brackets and hit enter the Round off of the number is evaluated and displayed in the same cell as shown in the figure.
MOD : To use Mod formula just write =(equal to) MOD followed by the number in brackets as shown in the figure. As soon as you close the brackets and hit enter the Modulus of the number is evaluated and displayed in the same cell as shown in the figure.
SQRTPI : To use Sqrtpi formula just write =(equal to) SQRTPI followed by the number in brackets as shown in the figure. As soon as you close the brackets and hit enter the result is calculated and displayed in the same cell as shown in the figure.
SIN : To use Sin formula just write =(equal to) SIN followed by the angle in brackets as shown in the figure. As soon as you close the brackets and hit enter the sine of the angle evaluated and displayed in the same cell as shown in the figure.
COS : To use Cos formula just write =(equal to) COS followed by the angle in brackets as shown in the figure. As soon as you close the brackets and hit enter the Cosine of the angle evaluated and displayed in the same cell as shown in the figure.
Similarly you can use all of the above mentioned excel formulas.
Excel Cheat Sheet
Cheat sheet is not a sheet meant for cheating but it is a concise set of notes used for quick reference. They are named so because they maybe used by students in the test or exam for cheating purposes. Excel cheat sheet is used for quick reference of excel shortcuts and formulas. Visit cheat sheet to download excel cheat sheet.
No comments:
Post a Comment