Working in a browser spreadsheet instead? See our Google Sheets functions list.
401 Formulas
The ABS function returns the absolute value of a number, eliminating any negative sign for precise calculations.
The ACCRINT formula calculates accrued interest for bonds by inputting parameters like issue date, rate, and maturity for precise results.
The ACCRINTM function calculates accrued interest for bonds from issue date to maturity, providing a quick interest assessment.
The ACOS function calculates the arccosine of a number, returning the result in radians for accurate mathematical computations.
The ACOSH function calculates the inverse hyperbolic cosine of a number, useful for advanced mathematical and statistical analysis.
The ACOT function calculates the arccotangent of a number, returning the angle in radians for accurate mathematical computations.
The ACOTH function calculates the inverse hyperbolic cotangent of a number, useful for advanced mathematical analysis in Excel.
The ADDRESS function generates a cell reference based on specified row and column numbers, allowing dynamic referencing in formulas.
The AGGREGATE function performs advanced calculations while allowing you to ignore errors and customize results for better data analysis.
The AMORDEGRC function calculates depreciation for an asset based on its cost, purchase date, salvage value, and lifespan.
The AMORLINC function calculates an asset's depreciation over time, factoring in cost, purchase date, salvage value, and lifespan.
The AND function evaluates multiple conditions in Excel, returning TRUE only if all specified conditions are met for logical tests.
The ARABIC function converts Roman numeral text into Arabic numbers, streamlining numerical calculations in Excel.
The AREAS function counts the number of distinct areas in a specified range, aiding in efficient data analysis and management.
The ARRAYTOTEXT formula converts arrays into text format in Excel, enabling customized formatting for improved data presentation.
The ASIN function calculates the arcsine of a number, returning the angle in radians for inputs between -1 and 1.
The ASINH function calculates the inverse hyperbolic sine of a number, useful for advanced mathematical analysis in Excel.
The ATAN function calculates the arctangent of a number, returning the angle in radians for trigonometric calculations in Excel.
The ATAN2 function calculates the arctangent of the quotient of two numbers, returning the angle in radians.
The ATANH function calculates the inverse hyperbolic tangent of a number for precise mathematical analysis in Excel.
The AVEDEV function calculates the average of absolute deviations from the mean, helping assess data variability and dispersion in a dataset.
The AVERAGE function calculates the mean of a range of numbers, providing insights for accurate data analysis in Excel.
The AVERAGEA function calculates the average of a range, treating text as 0 and logical values as 1, including all data types in the range.
The AVERAGEIF function calculates the average of a range based on specified criteria, enhancing data analysis efficiency in Excel.
The AVERAGEIFS function calculates the average of a dataset based on specified criteria, allowing for precise data analysis in Excel.
The BASE function converts numbers to specified bases, allowing customization of radix and minimum length for flexible data representation.
The BIN2DEC function converts binary numbers to decimal format, facilitating easier data analysis and calculations in Excel.
The BIN2HEX function converts binary numbers to hexadecimal format, aiding in data analysis and format management in Excel.
The BIN2OCT function converts binary numbers to octal format, allowing for customizable output length with the optional places argument.
The BINOM.DIST formula calculates the probability of a specific number of successes in a binomial distribution based on trials and success rate.
The BINOMDIST formula calculates the probability of achieving a specific number of successes in a binomial distribution scenario.
The BITAND function performs a bitwise AND operation between two numbers, returning a number that represents the common bits set to 1.
The BITLSHIFT formula shifts bits to the left, multiplying the number by 2 for each shift, useful for advanced data manipulation.
The BITOR function performs a bitwise OR operation between two numbers, useful for efficient data manipulation in Excel.
The BITRSHIFT function shifts bits of a number to the right, effectively dividing it by powers of two for data manipulation.
The BITXOR function performs a bitwise XOR operation between two numbers, useful for efficient data analysis in Excel.
The =BYCOL function applies a lambda function to each column in a range, streamlining data analysis and manipulation in Excel.
The =BYROW(array, lambda) formula applies a specified function to each row in an array, streamlining data analysis in Excel.
The CEILING function rounds numbers up to the nearest specified significance, ensuring precise calculations in Excel.
The CEILING.MATH function rounds numbers up to the nearest specified significance, helping to standardize values in calculations.
The CEILING.PRECISE function rounds numbers up to the nearest specified significance, ensuring accurate and precise calculations in Excel.
The =CELL(info_type, [reference]) formula retrieves details about a cell's formatting, location, or contents in Excel.
The CHAR function converts numeric ASCII codes into their corresponding characters, simplifying text manipulation in Excel.
The CHOOSE function selects a value from a list based on a specified index number, streamlining data retrieval and management in Excel.
The CHOOSECOLS function selects specific columns from an array, simplifying data analysis by focusing on relevant information.
The CHOOSEROWS function selects specific rows from an array, enhancing data analysis by allowing targeted data retrieval.
The CLEAN function in Excel removes non-printable characters from text, ensuring your data is clean and easy to read in spreadsheets.
The =CODE(text) formula returns the numeric ASCII code of the first character in a text string, aiding in data analysis and manipulation.
The =COLUMN([reference]) formula returns the column number of a specified cell or range, aiding in data analysis and referencing.
The COLUMNS function counts the number of columns in a specified array or range, providing a quick way to assess data structure.
The COMBIN function calculates the number of combinations for a given number of items, helping you choose subsets from a larger set.
The COMBINA function calculates the number of combinations of n items taken k at a time, useful for statistical analysis.
The COMPLEX function creates complex numbers from real and imaginary parts, aiding in advanced data analysis in Excel.
The CONCAT function combines multiple text strings into one, improving data organization and presentation in Excel.
The CONCATENATE function combines multiple text strings into one, improving data organization and presentation in Excel.
The CONVERT function is used to change a value from one unit of measurement to another in Excel, simplifying unit conversions.
The COS function calculates the cosine of an angle in radians, aiding in precise trigonometric analysis within Excel.
The COSH function calculates the hyperbolic cosine of a number, useful in advanced math and engineering contexts.
The COT keyword calculates the cotangent of an angle in radians for precise trigonometric analysis using the =COT(number) formula in Excel.
The COTH function calculates the hyperbolic cotangent of a number, useful for advanced mathematical analysis and data modeling.
The COUNT function in Excel counts numeric entries in a specified range, helping to analyze data effectively.
The COUNTA function counts non-empty cells in a specified range, aiding in effective data analysis and summarization.
The COUNTBLANK function counts the number of empty cells in a specified range, helping identify gaps in data entry.
The COUNTIF function counts the number of cells in a range that meet a specified condition or criteria.
The COUPDAYBS function calculates the number of days from the settlement date to the next coupon payment date for a bond.
The COUPDAYS function calculates the number of coupon payment days between settlement and maturity dates for a security.
The COUPDAYSNC function calculates the number of days from the settlement date to the next coupon payment date for a security.
The COUPNCD function calculates the next coupon payment date for bonds, based on the settlement and maturity dates provided.
The COUPNUM function calculates the total number of coupon payments between the settlement date and maturity date of a bond.
The COUPPCD function calculates the next coupon payment date for bonds, simplifying bond analysis by providing essential payment timing information.
The CSC function calculates the cosecant of an angle in radians, useful for trigonometric calculations in Excel.
The CSCH function calculates the hyperbolic cosecant of a number for advanced mathematical analysis in Excel.
The CUMIPMT function calculates cumulative interest payments over a specified period, using rate, periods, present value, and payment timing.
The CUMPRINC formula calculates total principal payments over a period, using interest rate, periods, present value, and payment timing.
The DATE function creates a date in Excel by specifying the year, month, and day for accurate formatting and calculations.
Calculate complete years, months, or days between two dates with DATEDIF, including unit choices, #NUM! behavior, and MD limitations.
The DATEVALUE function converts date text into a serial number for easier date calculations and analysis in Excel.
The DAVERAGE function calculates the average of a specified field in a database that meets defined criteria.
The DAY function extracts the day from a date in Excel, helping simplify date analysis and improve data management.
The DAYS function calculates the number of days between two dates, providing a simple way to find date differences in Excel.
The DAYS360 function calculates the number of days between two dates based on a 360-day year, with options for different day count conventions.
The DB function calculates depreciation for an asset based on its database, field, and specified criteria for precise financial evaluation.
The DCOUNT function counts the number of records in a database that meet specified criteria, aiding in precise data analysis.
The DCOUNTA function counts non-empty entries in a database that meet specified criteria, helping analyze data effectively.
The DDB function calculates asset depreciation using the double declining balance method, factoring in cost, salvage value, life, and period.
The DEC2BIN function converts decimal numbers to binary format, allowing customization of output length with the optional places argument.
The DEC2HEX function converts decimal numbers to hexadecimal format in Excel, with an option for padding digits.
The DEC2OCT function converts decimal numbers to octal format in Excel, with an option to specify the number of digit places.
The DECIMAL function converts numbers from a specified base (radix) to decimal format, allowing for easy numerical analysis in Excel.
The DEGREES function converts radians to degrees in Excel, simplifying angle calculations with the formula =DEGREES(radians).
The DELTA function compares two numbers, returning 1 if they are equal and 0 if they are not, useful for logical tests in Excel.
The DEVSQ function calculates the sum of squared deviations from the mean, aiding in statistical analysis and providing data insights.
The DGET function retrieves a single value from a database that meets specified criteria, aiding in targeted data analysis.
The DISC function calculates the discount on a security based on settlement, maturity, rate, yield, redemption, frequency, and basis.
The DMAX function returns the highest value from a specified field in a database that meets given criteria.
The DMIN function finds the minimum value in a database that meets specified criteria, aiding in efficient data analysis.
The DOLLAR function formats numbers as currency, allowing customization of decimal places for precise financial reporting.
The DOLLARDE function converts fractional dollar amounts to decimal, simplifying financial calculations in Excel.
The DOLLARFR function converts decimal numbers into fractional dollar amounts for accurate financial calculations.
The DPRODUCT function multiplies values in a specified field of a database that meet defined criteria.
The DROP function removes designated rows and columns from an array, simplifying data for analysis and enhancing clarity in Excel.
The DSTDEV function calculates the standard deviation of a specified field in a database that meets given criteria.
The DSTDEVP function calculates the standard deviation of a population based on specified criteria in a database for precise statistical analysis.
The =DSUM function calculates the sum of a specified field in a database that meets defined criteria.
The DURATION formula calculates a bond's Macaulay duration using settlement, maturity, coupon, yield, frequency, and basis as inputs.
The DVAR function calculates the variance of a dataset based on given criteria, aiding in precise data analysis.
The DVARP function calculates the variance of a population based on specified criteria within a data set in Excel.
The EDATE function calculates future dates by adding a specified number of months to a start date for effective date management.
The EFFECT formula calculates the effective interest rate from a nominal rate and compounding periods, reflecting true borrowing costs.
The ENCODEURL function converts text into a URL-encoded format, making it suitable for web use by replacing special characters.
The EOMONTH function calculates the last day of a month, given a start date and a number of months to add or subtract.
The =ERROR.TYPE(error_val) formula identifies specific error types in Excel, aiding in effective data troubleshooting and analysis.
The EVEN function rounds a number up to the nearest even integer, ensuring consistent and accurate data analysis in Excel.
The EXACT function compares two text strings for exact matches, returning TRUE for a match and FALSE otherwise.
The EXP function calculates the exponential value of a number, useful for advanced math and finance in Excel.
The EXPAND function resizes arrays by adding rows and columns, allowing for padding of empty spaces to enhance data organization.
The FACT function calculates the factorial of a number by multiplying all positive integers up to that number in Excel.
The FACTDOUBLE function calculates the double factorial of a number, useful for advanced mathematical computations in Excel.
The =FALSE() formula returns the logical value FALSE, aiding in conditional statements and data validation within Excel.
The FIELDVALUE function retrieves specific values from a designated field in a data table for efficient data analysis.
The FILTER function extracts data from a range based on specified criteria, allowing customization for empty results.
The FILTERXML function extracts data from XML documents using specified XPath queries for efficient data retrieval in Excel.
The FIND function locates specific text within a string, starting from a specified position, returning the text's starting index.
The FIXED function formats numbers with a set number of decimal places and can remove commas for clearer data presentation.
The FLOOR function rounds down a number to the nearest specified significance, aiding in precise data analysis and reporting.
The FLOOR.MATH function rounds numbers down to the nearest specified significance, simplifying calculations in Excel.
The FLOOR.PRECISE function rounds down a number to the nearest specified significance, ignoring any fractional part.
The FORECAST function predicts future values using existing x and y data trends, helping to estimate outcomes based on historical data.
The FORECAST.ETS function predicts future values using historical data and seasonal patterns, enhancing forecasting accuracy in Excel.
The FORECAST.ETS.CONFINT formula predicts future values and provides confidence intervals based on historical data trends in Excel.
The FORECAST.ETS.SEASONALITY formula estimates the seasonal pattern in time series data, helping identify trends over specific intervals.
The =FORECAST.ETS.STAT formula predicts future values based on historical data, accounting for seasonality and data gaps.
The =FORECAST.LINEAR function predicts future y values based on known x and y values, using linear regression to identify trends.
The FORMULATEXT function retrieves and displays the formula from a specified cell, aiding in auditing and formula tracking in Excel.
The FREQUENCY formula calculates how often data points fall within defined intervals, or bins, providing a distribution of values.
The FV function calculates the future value of an investment based on interest rate, payment periods, and optional present value and type.
The FVSCHEDULE function calculates the future value of an investment based on a principal and a series of compound interest rates.
The GCD function calculates the greatest common divisor of two or more numbers, aiding in efficient mathematical problem-solving in Excel.
The GEOMEAN function calculates the geometric mean of a range of numbers, providing an accurate average for multiplicative datasets.
The GETPIVOTDATA function retrieves specific data from a pivot table, allowing for efficient data extraction and analysis.
The GROUPBY function organizes data by specified columns and allows for summarization using various aggregation methods.
The HARMEAN function calculates the harmonic mean of a dataset, providing a more accurate average for rates and ratios in analysis.
The HEX2BIN function converts hexadecimal numbers to binary, allowing you to specify the number of bits for consistent formatting.
The HEX2DEC function converts hexadecimal numbers to decimal format for easier numerical analysis and data manipulation in Excel.
The HEX2OCT function converts hexadecimal numbers to octal format in Excel, streamlining data conversion tasks efficiently.
The HLOOKUP function searches for a value in the top row of a horizontal table and returns a corresponding value from a specified row below.
The HOUR function extracts the hour from a time serial number in Excel, aiding in time analysis and calculations.
The HSTACK function combines multiple arrays side by side, enhancing data organization and analysis in Excel.
The HYPERLINK formula creates clickable links in Excel, enabling quick access to web pages or documents directly from the spreadsheet.
The IF function evaluates a condition and returns one value if true and another if false, enabling dynamic decision-making in Excel.
The IFERROR function is used to return a specified value if a formula results in an error, ensuring cleaner and more user-friendly spreadsheets.
The IFNA function returns a specified value when a formula results in #N/A, helping to manage errors in Excel calculations.
The IFS function evaluates multiple conditions in Excel and returns specified values based on the first true condition met.
The IMABS function calculates the absolute value of a complex number in Excel, useful for data analysis and mathematical computations.
The IMAGE function allows users to insert and customize images in Excel, adjusting alt text, size, height, and width for better presentation.
The IMAGINARY function extracts the imaginary part of a complex number, aiding in advanced mathematical calculations in Excel.
The IMARGUMENT function extracts the angle (argument) from a complex number, simplifying calculations involving complex numbers in Excel.
The IMCONJUGATE function calculates the complex conjugate of a complex number for precise mathematical analysis in Excel.
The IMCOS function calculates the cosine of a complex number, providing precise results for complex number operations in Excel.
The IMCOSH function calculates the hyperbolic cosine of a complex number, useful in advanced math and engineering contexts.
The IMCOT function calculates the inverse cotangent of a complex number for accurate mathematical analysis in Excel.
The IMCSC function calculates the inverse of a complex number for accurate mathematical analysis in Excel.
The IMCSCH function calculates the inverse hyperbolic sine of a complex number, aiding in advanced mathematical analysis in Excel.
The IMDIV function is used to divide one complex number by another in Excel, returning the result as a complex number.
The IMEXP function calculates the exponential of a complex number, aiding in advanced mathematical analysis in Excel.
The IMLN function calculates the natural logarithm of a complex number for advanced mathematical analysis in Excel.
The IMLOG10 function calculates the base-10 logarithm of a complex number for accurate mathematical analysis in Excel.
The IMLOG2 function calculates the base-2 logarithm of complex numbers in Excel, simplifying complex data analysis tasks.
The IMPOWER function raises a complex number to a specified power, returning the result as a complex number in Excel.
The IMPRODUCT function multiplies multiple numbers together in Excel for efficient calculations and data analysis.
The IMREAL function extracts the real part of a complex number in Excel, aiding in efficient data analysis.
The IMSEC function calculates the imaginary secant of a complex number for accurate mathematical analysis in Excel.
The IMSECH function calculates the inverse hyperbolic secant of a number, useful in mathematics and engineering for solving hyperbolic equations.
The IMSIN function calculates the sine of a complex number in Excel, useful for advanced math and engineering tasks.
The IMSINH function calculates the hyperbolic sine of a complex number, useful in advanced math and engineering contexts.
The IMSQRT function calculates the square root of a complex number in Excel, useful for advanced math and engineering tasks.
The IMSUB function subtracts one complex number from another in Excel, allowing for efficient calculations with complex values.
The IMSUM function is used to calculate the sum of multiple complex numbers in Excel, simplifying complex number addition.
The IMTAN function calculates the inverse tangent of a complex number in Excel, aiding in complex number analysis and calculations.
The INDEX function retrieves values from a specified array using row and optional column numbers for precise data extraction.
The INDIRECT function allows you to create dynamic cell references, enabling flexible data manipulation in your Excel spreadsheets.
The INFO function retrieves information about the current Excel environment, such as the version, operating system, and settings.
The INT function rounds down a number to the nearest integer, aiding in data analysis and simplifying calculations in Excel.
The INTERCEPT function calculates the y-intercept of a linear regression line based on known y and x values in Excel.
The INTRATE function calculates the annual interest rate of an investment based on settlement, maturity, investment, and redemption values.
The IPMT function calculates interest payments on loans for specific periods, aiding in financial analysis and budgeting.
The IRR function calculates the internal rate of return for a series of cash flows, helping assess investment profitability over time.
The ISBLANK function checks if a specified cell is empty, returning TRUE for blank cells and FALSE for those containing data.
The ISERR function checks for errors in Excel, returning TRUE for all errors except #N/A, aiding in effective data management.
The ISERROR function checks if a value is an error, returning TRUE for errors and FALSE for non-errors in Excel.
The ISEVEN function checks if a number is even, returning TRUE for even numbers and FALSE for odd ones.
The ISFORMULA function checks if a specified cell contains a formula, useful for data validation and error checking in Excel.
The ISLOGICAL function checks if a value is TRUE or FALSE, useful for validating data and performing logical tests in Excel.
The ISNA function checks if a value is #N/A, allowing you to handle errors and enhance data accuracy in your Excel spreadsheets.
The ISNONTEXT function checks if a value is not text, returning TRUE for non-text values and FALSE for text entries.
The ISNUMBER function checks if a specified value is a number, useful for validating data and ensuring accuracy in spreadsheets.
The ISODD function checks if a number is odd, returning TRUE for odd numbers and FALSE for even numbers.
The ISOMITTED function checks for omitted values in Excel, returning TRUE if a value is omitted and FALSE if it is present.
The ISOWEEKNUM function calculates the ISO week number for a specified date, helping to organize data by week efficiently.
The ISPMT function calculates interest paid on a loan for a specific period, simplifying interest calculations in Excel.
The ISREF function checks if a value refers to a valid cell or range in Excel, aiding in data validation and error checking.
The ISTEXT function checks if a specified value is text, aiding in data validation and ensuring correct data types in spreadsheets.
The LAMBDA function allows users to define custom formulas with parameters, streamlining calculations and boosting productivity in Excel.
The LARGE function retrieves the k-th largest value from a specified array, helping analyze data effectively.
The LCM function calculates the least common multiple of two or more numbers in Excel, aiding in efficient data analysis.
The LEFT formula extracts a specified number of characters from the start of a text string in Excel, allowing for easy customization.
The LEN function counts the number of characters in a text string, aiding in efficient data analysis and management in Excel.
The LET function allows you to define variables in Excel, improving formula readability and performance by reusing calculations.
The LINEST function calculates the statistics for a linear regression model, helping analyze relationships between variables in data sets.
The LN function calculates the natural logarithm of a specified number, aiding in advanced mathematical analysis and data modeling.
The LOG function calculates logarithms in Excel, enabling users to define both the number and base for flexible mathematical computations.
The LOG10 function calculates the base-10 logarithm of a number, aiding in data analysis and simplifying mathematical computations.
The LOOKUP formula is used to search for a value in a range and return a corresponding value from another range efficiently.
The LOWER function converts any text string to lowercase, streamlining data formatting in Excel.
The MAKEARRAY function generates dynamic arrays by defining rows, columns, and custom calculations using lambda functions.
The =MAP function applies a custom lambda function to each element in an array, streamlining data manipulation in Excel.
The MATCH function locates the position of a specified value within a range, aiding in data analysis and lookup tasks in Excel.
The MAX function in Excel identifies the highest number in a range, streamlining data analysis by quickly highlighting maximum values.
The MAXA function returns the maximum value in a dataset, considering numbers, text, and logical values like TRUE and FALSE.
The MAXIFS formula finds the highest value in a range that meets specified criteria, streamlining data analysis with multiple conditions.
The MDETERM function calculates the determinant of a matrix, aiding in data analysis and mathematical computations in Excel.
The MDURATION function calculates a bond's modified duration, indicating its sensitivity to interest rate changes.
The MEDIAN function calculates the middle value of a data set, efficiently identifying the central point among numbers in Excel.
The MID function extracts characters from a text string by specifying the starting position and the number of characters to return.
The MIN function identifies the smallest number in a specified range, aiding in efficient data analysis and comparison of values.
The MINA function in Excel finds the minimum value in a dataset, considering numbers, text, and logical values like TRUE and FALSE.
The MINIFS function finds the smallest value in a range that meets specified criteria, allowing for efficient data analysis in Excel.
The MINUTE function extracts the minute component from a time value, aiding in time analysis and calculations in Excel.
The MINVERSE function calculates the inverse of a matrix, useful for advanced data analysis and solving linear equations in Excel.
The MIRR function calculates the modified internal rate of return using cash flows, finance rate, and reinvestment rate for investment evaluation.
The MMULT function multiplies two arrays (matrices) in Excel, enabling advanced data analysis through matrix operations.
The MOD function calculates the remainder of a division, aiding in data analysis and simplifying calculations in Excel.
The MODE function identifies the number that appears most often in a data set, helping you analyze frequency easily.
The MODE.MULT function returns multiple modes from a dataset, helping to identify the most frequently occurring values efficiently.
The MODE.SNGL function identifies the single most frequently occurring number in a data set, streamlining data analysis in Excel.
The MONTH function extracts the month from a date, returning it as a number for streamlined data analysis and reporting in Excel.
The MROUND function rounds a number to the nearest specified multiple, ensuring accurate and precise calculations in Excel.
The MUNIT function generates a square identity matrix based on the specified array size, useful for advanced mathematical operations.
The N function converts text or logical values to numbers in Excel, ensuring accurate calculations and data analysis.
The =NA() formula generates a #N/A error in Excel, signaling missing data or unavailable information in your spreadsheets.
The NETWORKDAYS formula calculates working days between two dates, excluding weekends and specified holidays.
The NETWORKDAYS.INTL function calculates working days between two dates, excluding weekends and specified holidays.
The NOMINAL function calculates the nominal interest rate from an effective rate and the number of compounding periods per year.
The NORM.DIST function calculates the normal distribution probability based on specified mean, standard deviation, and cumulative options.
The NORM.INV function calculates the inverse of the normal distribution for a given probability, mean, and standard deviation in Excel.
The NORM.S.DIST function calculates the standard normal distribution for a given z-score, useful for statistical analysis and probability assessments.
The NORM.S.INV function returns the z-score corresponding to a given probability in the standard normal distribution.
The NOT function in Excel reverses a logical value, yielding TRUE for FALSE and FALSE for TRUE, aiding in logical evaluations.
The NOW function displays the current date and time in Excel, updating automatically whenever the worksheet recalculates.
The NPER function calculates the number of periods for an investment or loan based on rate, payment, present value, and optional future value.
The NPV function calculates the net present value of an investment by discounting future cash flows to assess profitability over time.
The NUMBERVALUE function converts text to numbers, allowing customization of decimal and group separators for accurate data representation.
The ODD function rounds a number up to the nearest odd integer, simplifying data analysis and ensuring consistent odd values.
The ODDFPRICE function calculates the price of an odd first coupon bond by inputting parameters like settlement date, maturity date, and coupon rate.
The ODDFYIELD function calculates the yield of an odd coupon bond using parameters like settlement, maturity, and coupon rate.
The ODDLPRICE function calculates the odd-lot price of a bond by inputting settlement, maturity, rate, yield, and other parameters.
The ODDLYIELD function calculates a bond's yield based on settlement, maturity, rate, price, redemption, frequency, and basis.
The OFFSET function allows you to create dynamic cell references by specifying the number of rows and columns to shift from a starting point.
The OR function evaluates multiple conditions in Excel, returning TRUE if at least one condition is true, aiding in data analysis.
The PDURATION formula calculates the time needed to grow a present value to a future value at a given interest rate.
The PERCENTILE function calculates the k-th percentile of a data set, helping analyze distribution for informed decision-making.
The PERCENTILE.EXC function calculates the k-th percentile of a dataset, excluding the minimum and maximum values for accurate analysis.
The PERCENTILE.INC function calculates the k-th percentile of a data set, helping to understand the distribution of values within it.
The =PERCENTOF formula calculates a number's percentage relative to a total, aiding in data analysis and decision-making.
The PERCENTRANK function calculates the relative rank of a value in a dataset, indicating its position within the overall distribution.
The PERCENTRANK.EXC function calculates the relative rank of a value in a dataset, excluding the highest and lowest ranks.
The PERCENTRANK.INC function calculates the relative rank of a value in a dataset, returning its percentile rank.
The PERMUT function calculates the number of ways to arrange a subset of items from a larger set, aiding in data analysis.
The PERMUTATIONA function calculates the number of permutations of n items taken r at a time, allowing for repetitions in data analysis.
The PI() function returns the mathematical constant pi (π) for precise calculations in math and engineering applications.
The PIVOTBY function dynamically analyzes data, enabling custom pivoting based on specified criteria and value ranges for insightful reporting.
The PMT function calculates loan payments by using the interest rate, number of periods, present value, and optional future value/type.
The POWER function raises a number to a specified exponent, streamlining calculations and enhancing data analysis in Excel.
The PPMT function calculates the principal portion of a loan payment for a specific period, aiding in loan and investment management.
The PRICE function calculates a bond's price based on settlement, maturity, coupon rate, yield, redemption value, payment frequency, and day count basis.
The PRICEDISC function calculates the price of a discounted security by considering settlement, maturity, discount rate, and redemption value.
The PRICEMAT function calculates the price of a maturity bond based on settlement, maturity, issue dates, rate, yield, and basis.
The PRODUCT formula multiplies multiple numbers in Excel, streamlining calculations for efficient data analysis in your spreadsheets.
The PROPER function transforms text to proper case, capitalizing the first letter of each word for enhanced readability in Excel.
The PV function calculates the present value of an investment or loan based on interest rate, number of periods, payment amount, and future value.
The =QUARTILE function calculates quartiles in a dataset, aiding in data analysis and understanding distribution effectively.
The =QUARTILE.EXC function calculates exclusive quartiles, providing precise statistical analysis by excluding the median from the quartile calculations.
The =QUARTILE.INC function calculates quartiles in a dataset, helping analyze data distribution effectively.
The QUOTIENT function divides two numbers and returns the integer part of the result, ignoring any remainder for precise calculations.
The RADIANS function converts degrees to radians, simplifying trigonometric and geometric calculations in Excel.
The RAND function generates random numbers between 0 and 1, useful for simulations, sampling, and data analysis in Excel.
The RANDARRAY function generates a dynamic array of random numbers, allowing you to specify the number of rows, columns, and integer range.
The RANDBETWEEN formula generates random integers within a specified range, aiding in dynamic data analysis and simulations.
Rank numbers in Excel with RANK.EQ, choose descending or ascending order, and understand ties, RANK.AVG, and legacy RANK.
The =RANK.AVG formula calculates the average rank of a number in a dataset, allowing for customizable ranking order options.
The RANK.EQ function ranks numbers in a dataset, allowing you to specify whether to order them in ascending or descending order.
The RATE function calculates the interest rate for an investment or loan based on payments, present value, and future value inputs.
The RECEIVED formula calculates the present value of a bond's cash flows using issue number, dates, and discount rate.
The =REDUCE function aggregates data using a custom initial value and a lambda function for efficient calculations in Excel.
The REGEXEXTRACT function retrieves specific text patterns using a defined regular expression for accurate data extraction in Excel.
The REGEXREPLACE function replaces text patterns in a string using regular expressions for efficient data manipulation in Excel.
The REGEXTEST function checks if a text string matches a given regular expression pattern, returning TRUE or FALSE based on the match.
The REPLACE function in Excel modifies text by replacing specified characters with new ones, streamlining text editing tasks.
The REPT function repeats text a specified number of times, enhancing data presentation and formatting in Excel.
The RIGHT function extracts a specified number of characters from the end of a text string in Excel.
The =ROMAN function converts numbers to Roman numerals in Excel, with an optional second argument to customize the numeral format.
The ROUND function rounds a number to a specified number of digits, enhancing accuracy in calculations and improving data presentation.
The ROUNDDOWN function in Excel rounds numbers down to a specified number of digits for accurate data analysis.
The ROUNDUP formula rounds numbers up to a specified number of digits, ensuring accuracy in data analysis and reporting.
The ROW function returns the row number of a specified cell or range, helping identify its position in the spreadsheet.
The ROWS function counts the number of rows in a specified range or array, providing a quick way to determine row totals in Excel.
The RRI function calculates the annual interest rate required to grow an investment from present value (pv) to future value (fv) over a specified period (nper).
The SCAN function in Excel enables cumulative calculations using LAMBDA for dynamic data analysis, enhancing data insights effectively.
The SEARCH function locates specific text in a string, beginning at a specified position, returning the starting index of the found text.
The SEC function calculates the secant of an angle in radians, useful for precise trigonometric analysis and applications in Excel.
The SECH function calculates the hyperbolic secant of a number, useful in advanced math and engineering contexts.
The SECOND function extracts the seconds from a time value, aiding in precise time analysis in Excel.
The SEQUENCE function generates a list of sequential numbers in Excel, allowing customization of rows, columns, start value, and step increment.
The SHEET function retrieves the sheet number of a specified reference, aiding in efficient data organization and management in Excel.
The SHEETS function counts the total number of sheets in a workbook or a specified reference, helping users manage their data effectively.
The SIGN function returns 1 for positive numbers, -1 for negative numbers, and 0 for zero, helping identify a number's sign in Excel.
The SIN function calculates the sine of an angle in radians, aiding in precise trigonometric analysis in Excel.
The SINH function calculates the hyperbolic sine of a number, useful for advanced mathematical analysis and data modeling in Excel.
The SKEW function calculates the skewness of a data set, indicating the asymmetry of its distribution around the mean.
The SKEW.P function calculates the skewness of a dataset, helping to analyze its distribution and identify any asymmetry present.
The SLN function calculates straight-line depreciation for an asset, providing consistent annual expense for accurate financial tracking.
The SLOPE function calculates the slope of a linear regression line based on known_y's and known_x's data sets in Excel.
The SMALL function retrieves the k-th smallest value from a specified array, helping to analyze data efficiently in Excel.
The SORT function organizes data by defining the sort index, order (ascending/descending), and orientation (rows/columns).
The SORTBY function sorts data dynamically based on specified criteria and order preferences, allowing for flexible data organization.
The SQRT function calculates the square root of a specified number, providing a quick method for mathematical analysis in Excel.
The STANDARDIZE function calculates a normalized value of a data point using its mean and standard deviation for comparison.
The STDEV formula calculates the standard deviation of a dataset in Excel, measuring the variability and dispersion of the data points.
The STDEV.P function calculates the population standard deviation, providing insights into data variability for accurate statistical analysis.
The STDEV.S function calculates the sample standard deviation, measuring data variability in a dataset by considering a sample rather than the entire population.
The STDEVA function calculates the standard deviation of a dataset, treating text as 0 and logical values as TRUE=1, FALSE=0.
The STDEVP function calculates the standard deviation of a population based on a set of numerical values for statistical analysis.
The STDEVPA function calculates the standard deviation of a dataset, treating text as zero and logical values as TRUE=1, FALSE=0.
The STOCKHISTORY formula retrieves past stock prices by specifying the ticker, date range, interval, and additional parameters.
The SUBSTITUTE function replaces specific text in a string, allowing you to target and modify specific instances of that text.
The SUBTOTAL function calculates results on filtered data, allowing for dynamic analysis without affecting hidden rows.
The SUMIF function sums values in a range that meet specified criteria, aiding in targeted data analysis and reporting.
The SUMIF function sums values in a range that meet specified criteria, allowing for conditional calculations in Excel.
The SUMIFS formula sums values in Excel based on multiple specified criteria, enhancing data analysis capabilities.
The SUMPRODUCT formula multiplies corresponding elements in arrays and sums the results, allowing for efficient calculations across multiple datasets.
The SQUAREROOT function calculates the square root, while SUMSQ computes the sum of squares of specified numbers.
The SUMX2MY2 function calculates the sum of the differences between the squares of two arrays for efficient data analysis.
The SUMX2PY2 function calculates the sum of the products of two arrays, aiding in efficient data analysis and comparison.
The SUMXMY2 function calculates the sum of the squares of differences between two arrays, aiding in data analysis and comparison.
The SWITCH function evaluates multiple conditions and returns a corresponding result, streamlining complex nested IF statements in Excel.
The SYD function calculates depreciation by considering the asset's cost, salvage value, useful life, and the specific period of depreciation.
The T function converts text to numeric values, ensuring accurate calculations and data analysis in Excel.
The TAKE function extracts specified rows and columns from an array, streamlining data analysis in Excel.
The TAN function calculates the tangent of an angle in radians, aiding in accurate trigonometric calculations in Excel.
The TANH function calculates the hyperbolic tangent of a number, useful for advanced mathematical and statistical analysis in Excel.
The TBILLEQ formula calculates the equivalent yield of a Treasury bill, considering settlement date, maturity date, discount rate, and basis.
The TBILLPRICE function calculates the price of a Treasury bill using settlement date, maturity date, and discount rate as inputs.
The TBILLYIELD function calculates the yield of a Treasury bill using settlement date, maturity date, and discount rate inputs.
The TEXT function converts numbers to text in a specified format, enhancing data presentation in Excel.
The TEXTAFTER function extracts text following a specified delimiter, allowing for customizable match modes and additional options.
The TEXTBEFORE function extracts text from a string, returning everything before a specified delimiter for better data organization.
The TEXTJOIN function combines text from multiple cells using a delimiter, excluding empty cells for cleaner results.
The TEXTSPLIT function divides text into separate cells based on specified delimiters, allowing customization and handling of empty values.
The TIME function creates a time value from given hours, minutes, and seconds for precise time calculations in Excel.
The TIMEVALUE function converts a text time into a decimal value for precise time calculations in Excel.
The =TOCOL formula in Excel converts arrays into a single column, allowing for empty cell exclusion and delimiter customization.
The =TODAY() formula displays the current date in Excel, updating automatically each time the spreadsheet is opened or recalculated.
The TOROW function converts an array into a single row, allowing you to ignore empty cells for a neater data display.
The TRANSPOSE function changes the orientation of data, switching rows to columns and columns to rows for improved data organization.
The TRIM function removes extra spaces from text, ensuring clean data for analysis by eliminating leading, trailing, and multiple spaces.
The TRIMMEAN function calculates the average of a dataset while excluding a specified percentage of the highest and lowest values.
The =TRUE() formula in Excel returns a logical TRUE value, useful for data analysis and setting conditions in formatting rules.
The TRUNC function in Excel removes decimal places from a number, allowing you to specify how many digits to keep.
The =TYPE(value) formula identifies the data type of a specified value, aiding in data analysis and ensuring accurate data handling.
The =UNICHAR(number) formula in Excel displays Unicode characters corresponding to their numeric codes, enhancing spreadsheet visuals.
The UNICODE function retrieves the Unicode value of a specified character in Excel, aiding in data analysis and character encoding tasks.
The UNIQUE function extracts distinct values from a range, allowing for column-wise extraction and exact match options.
The UPPER function converts any text string to uppercase letters, simplifying data formatting in Excel.
The VALUE function converts text representations of numbers into numeric values for accurate calculations in Excel.
The VALUETOTEXT formula converts numeric values to text in Excel, with optional formatting for customization.
The VAR function calculates the variance of a dataset in Excel, measuring data variability by analyzing multiple input numbers.
The VAR.P function calculates the population variance of a dataset, providing insights into data dispersion. Input your values for analysis.
The VAR.S function calculates the sample variance of a dataset, providing insights into data variability for statistical analysis.
The VARA function calculates the variance of a dataset, including numbers and text, for precise statistical analysis in Excel.
The VARP function calculates the variance of a population by analyzing the specified data range to measure variability.
The VARPA function calculates the population variance in Excel, considering text and logical values in its computation.
The VDB function calculates depreciation for an asset, considering cost, salvage value, life, and specific periods for accurate financial reporting.
The VLOOKUP function searches for a value in the first column of a table and returns a corresponding value from a specified column.
The VSTACK function combines multiple arrays into a single vertical array for streamlined data organization and analysis in Excel.
The =WEBSERVICE(url) formula fetches data from online sources directly into Excel for easy integration and analysis.
The WEEKDAY function in Excel returns the day of the week for a given date, allowing for different numbering systems based on user preference.
The WEEKNUM function calculates the week number of a given date, allowing for different return types based on week start preferences.
The WORKDAY formula calculates future workdays by adding a specified number of days to a start date, excluding weekends and holidays.
The WORKDAY.INTL function calculates workdays by excluding weekends and specified holidays, allowing for customized weekend definitions.
The WRAPCOLS function organizes data into a specified number of columns, allowing for optional padding to improve readability.
The =WRAPROWS function organizes data into specified row counts, allowing for padding and customization of the output format.
The XIRR function calculates the internal rate of return for cash flows with irregular dates, aiding in financial analysis and investment decisions.
The XLOOKUP function retrieves data from a range, allowing for customizable handling of missing values and different search modes.
The XMATCH function locates a value's position in a range, allowing for flexible match types and search directions.
The XNPV function calculates the net present value of cash flows at irregular intervals, factoring in specific dates for each cash flow.
The XOR function evaluates multiple conditions, returning TRUE if an odd number of its arguments are TRUE, otherwise FALSE.
The YEAR function extracts the year from a date, allowing for precise data analysis and reporting in Excel.
The YEARFRAC function calculates the fractional year between two dates in Excel, allowing for customizable basis options for precision.
The YIELD function calculates a bond's yield based on settlement, maturity, rate, price, redemption, frequency, and basis inputs.
The YIELDDISC formula calculates the yield of a discounted security using settlement, maturity, discount, and redemption values.
The YIELDMAT function calculates a bond's yield based on settlement, maturity, issue date, coupon rate, price, and day count basis.
42 Tutorials
Excel Conditional Formatting allows users to apply specific formatting to cells based on their values, enhancing data visualization and analysis.
To add a column in Excel, right-click the column header where you want the new column, select "Insert," and a new column will appear.
To alphabetize in Excel, select your data, go to the "Data" tab, and click "Sort A to Z" for ascending or "Sort Z to A" for descending order.
To autofit in Excel, double-click the boundary line between column headers or select the column(s) and press Alt + H, O, I.
Calculate percentages, percentage change, and increases in Excel with practical formulas and correct percentage formatting.
To combine two columns in Excel, use the CONCATENATE function or the "&" operator. For example, =A1 & B1 or =CONCATENATE(A1, B1).
To copy a formula in Excel, drag the fill handle (small square at cell corner) down or across to apply the formula to adjacent cells.
To count unique values in Excel, use the formula `=SUM(1/COUNTIF(range, range))` or the `UNIQUE` function in newer versions.
To create a Pivot Table in Excel, select your data, go to the "Insert" tab, click "PivotTable," choose your settings, and analyze your data.
To divide in Excel, use the formula `=A1/B1`, replacing A1 and B1 with your cell references. Press Enter to see the result.
To enable macros in Excel, go to File > Options > Trust Center > Trust Center Settings > Macro Settings, then select "Enable all macros."
To filter in Excel, select your data range, click the "Data" tab, then "Filter." Use dropdown arrows to choose criteria and display specific data.
To find circular references in Excel, go to the "Formulas" tab, click "Error Checking," and select "Circular References" to identify them.
To find duplicates in Excel, select your data, go to the "Data" tab, click "Remove Duplicates," or use "Conditional Formatting" to highlight them.
To freeze a row in Excel, select the row below it, go to the "View" tab, click "Freeze Panes," then choose "Freeze Top Row."
To freeze panes in Excel, select the row or column below/next to where you want the freeze, then go to View > Freeze Panes.
To highlight duplicates in Excel, select your data range, go to "Home," click "Conditional Formatting," choose "Highlight Cells Rules," then "Duplicate Values."
To insert a checkbox in Excel, go to the "Developer" tab, click "Insert," select the checkbox icon, then click on the desired cell to place it.
To insert multiple rows in Excel, select the same number of existing rows, right-click, and choose "Insert." New rows will appear above the selected ones.
To lock a row in Excel, select the row, go to the "View" tab, click "Freeze Panes," and choose "Freeze Top Row" to keep it visible while scrolling.
To lock cells in Excel, select the cells, right-click, choose Format Cells, go to the Protection tab, check "Locked," then protect the sheet.
To copy an Excel sheet, right-click the sheet tab, select "Move or Copy," check "Create a copy," and click "OK."
To make a graph in Excel, select your data, go to the "Insert" tab, choose a chart type, and customize it as needed.
To create a histogram in Excel, select your data, go to the "Insert" tab, choose "Histogram" from the Chart options, and customize as needed.
To create a line graph in Excel, input your data, select it, click "Insert," choose "Line Chart," and customize as needed.
To create a pie chart in Excel, select your data, go to the "Insert" tab, click "Pie Chart," and choose your preferred style.
To create a table in Excel, select your data range, then go to the "Insert" tab and click "Table." Confirm the range and click "OK."
To merge cells in Excel, select the cells, then click "Merge & Center" in the Home tab. This combines them into one larger cell.
To multiply in Excel, use the formula =A1*B1, replacing A1 and B1 with your cell references. Press Enter to see the result.
To password protect an Excel file, go to File > Info > Protect Workbook > Encrypt with Password, then enter and confirm your desired password.
To remove blank rows in Excel, select your data, go to the "Data" tab, click "Filter," then uncheck "Blanks" and delete the visible rows.
To remove duplicates in Excel, select your data, go to the "Data" tab, click "Remove Duplicates," and follow the prompts to clean your dataset.
To separate names in Excel, use the "Text to Columns" feature under the Data tab. Choose a delimiter (like space or comma) to split names.
To sort in Excel, select your data, go to the "Data" tab, click "Sort," choose your sorting criteria, and click "OK" to organize your data.
To split cells in Excel, select the cell, go to the "Data" tab, click "Text to Columns," choose a delimiter, and follow the prompts.
To strikethrough text in Excel, select the cell, press Ctrl + 1, go to the Font tab, and check the "Strikethrough" option. Click OK.
To subtract in Excel, use the formula =A1-B1, replacing A1 and B1 with your cell references. Press Enter to see the result.
To transpose data in Excel, select the data, copy it, right-click where you want to paste, choose "Paste Special," and select "Transpose."
To unhide columns in Excel, select the columns around the hidden ones, right-click, and choose "Unhide" from the context menu.
To unhide rows in Excel, select the rows around the hidden ones, right-click, and choose "Unhide" from the context menu.
To unprotect an Excel sheet, go to the "Review" tab, click "Unprotect Sheet," and enter the password if prompted. If forgotten, use recovery tools.
To wrap text in Excel, select the cell, go to the Home tab, and click "Wrap Text" in the Alignment group. This adjusts the cell height automatically.
Get AI-powered formula generation, explanations, and data analysis.