the formulas available in Excel:

 

You get to learn all the formulas in a way that is easy for you to use Microsoft Excel

Here is a list of all the formulas available in Excel:

• ABS: Returns the absolute value of a number.
• ACOS: Returns the arc cosine of a number.
• ACOSH: Returns the inverse hyperbolic cosine of a number.
• ADD: Adds two or more numbers together.
• AVERAGE: Calculates the average of a range of numbers.
• AVERAGEA: Calculates the average of a range of numbers, including text and numbers.
• AVERAGEIF: Calculates the average of a range of numbers that meet a specified condition.
• AVEDEV: Calculates the average deviation from the mean of a range of numbers.
• BAHTTEXT: Converts a number to Thai baht text.
• BASE: Converts a number to a different base.
• BESSELI: Returns the modified Bessel function of the first kind of order n for a number x.
• BESSELJ: Returns the Bessel function of the first kind of order n for a number x.
• BESSELK: Returns the modified Bessel function of the second kind of order n for a number x.
• BIN2DEC: Converts a binary number to a decimal number.
• BINOMDIST: Returns the probability of getting x successes in n trials, where the probability of success is p.
• BITAND: Returns the bitwise AND of two numbers.
• BITLSHIFT: Shifts the bits of a number to the left by a specified number of places.
• BITOR: Returns the bitwise OR of two numbers.
• BITRSHIFT: Shifts the bits of a number to the right by a specified number of places.
• CEILING: Rounds a number up to the nearest integer.
• CHAR: Returns the character associated with a number.
• CHIDIST: Returns the probability of a chi-squared value being less than or equal to a specified value.
• CHIINV: Returns the inverse of the chi-squared cumulative distribution function.
• CHOOSE: Returns a value from a list of values, based on a number.
• CLEAN: Removes all non-printing characters from a text string.
• CODE: Returns the Unicode code point of the first character in a text string.
• CONCATENATE: Combines two or more text strings into a single text string.
• CONFIDENCE: Returns the confidence interval for a population mean.
• CONVERT: Converts a number from one measurement system to another.
• COS: Returns the cosine of an angle.
• COSH: Returns the hyperbolic cosine of an angle.
• COUNT: Counts the number of cells in a range that contain numbers.
• COUNTA: Counts the number of cells in a range that are not blank.
• COUNTBLANK: Counts the number of cells in a range that are blank.
• COUNTIF: Counts the number of cells in a range that meet a specified condition.
• COUNTUNIQUE: Counts the number of unique values in a range.
• CUBEKPIMEMBER: Returns a member of a cube KPI.
• CUBEMEMBER_EXPRESSION: Returns the expression for a member of a cube.
• CUBEMEMBERPROPERTY: Returns the value of a property for a member of a cube.
• CUBERANKEDMEMBER: Returns the kth ranked member of a list of members, where k is specified by the rank argument.
• CUBESETCOUNT: Returns the number of members in a set.
• CUBESETRANGE: Returns a range of members in a set.
• DATE: Returns the serial number of a date.
• DATEVALUE: Converts a text string to a date.
• DAY: Returns the day of the month from a date serial number.
• DDB: Returns the depreciation of an asset over a specified period of time using the double declining balance method.
• DECIMAL: Converts a number to a decimal number.
• DEGREES: Converts radians to degrees.
• DELTA: Returns TRUE if two expressions are equal and FALSE if they are not equal.
• DEVSQ: Calculates the squared deviations from the mean of a range of numbers.
• EDATE: Returns the serial number of the date that is a specified number of days before or after a date.
• EVEN: Rounds a number up to the nearest even integer.
• EXP: Returns the exponential of a number.
• FACT: Returns the factorial of a number.
• FALSE: Returns the logical value FALSE.
• FDIST: Returns the F-distribution probability for specified values of degrees of freedom and the F-value.
• SUM: Adds up the values in a range of cells.
• AVERAGE: Calculates the average of the values in a range of cells.
• COUNT: Counts the number of cells in a range that contain numbers.
• MAX: Finds the maximum value in a range of cells.
• MIN: Finds the minimum value in a range of cells.
• IF: Performs a logical test and returns one value if the test is true and another value if the test is false.
• AND: Returns TRUE if all of the arguments are TRUE and FALSE if any of the arguments are FALSE.
• OR: Returns TRUE if any of the arguments are TRUE and FALSE if all of the arguments are FALSE.
• NOT: Reverses the logical value of an argument.
• VLOOKUP: Looks up a value in a table and returns the corresponding value from another column in the table.
• HLOOKUP: Looks up a value in a table and returns the corresponding value from another row in the table.
• SUMIF: Adds up the values in a range of cells that meet a specified condition.
• COUNTIF: Counts the number of cells in a range that meet a specified condition.
• AVERAGEIF: Calculates the average of the values in a range of cells that meet a specified condition.