How many formulas are there in excel

If this AND that. IF AND. IF with boolean logic. IF with other calculations. IF with wildcards. Invoice status with nested if. Nested IF function example. Only calculate if not blank.

Return blank if. Show checkmark if complete. Tax rate calculation with fixed base. Two-tier sales tax calculation. Win loss points calculation. Categorize text with keywords. Group arbitrary text values. Group numbers at uneven intervals. Group times into 3 hour buckets. Group times into unequal buckets. If cell contains one of many things. Map inputs to arbitrary values. Map text to numbers. Running count group by n size.

Highlight 3 smallest values with criteria. Conditional formatting based on another cell. Conditional formatting based on another column. Conditional formatting column is blank. Conditional formatting date past due. Conditional formatting dates overlap. Conditional formatting highlight target percentage. Conditional formatting last n rows. Find duplicate values in two columns. Gantt chart. Gantt chart by week. Gantt chart time schedule. AND OR. Gantt chart with weekends. Highlight approximate match lookup conditional formatting.

Highlight blank cells. Highlight bottom values. Highlight cells that begin with. Highlight cells that contain. Highlight cells that contain one of many. Highlight cells that end with. Highlight cells that equal. Highlight column differences. Highlight data by quartile. Highlight dates between. Highlight dates greater than. Highlight dates in same month and year.

Highlight dates in the next N days. Highlight dates that are weekends. Highlight duplicate columns. Highlight duplicate rows. Highlight duplicate values. Highlight entire rows. Highlight every other row.

Highlight integers only. Highlight many matching values. Highlight missing values. Highlight multiples of specific value. Highlight numbers that include symbols. Highlight row and column intersection exact match. OR AND. Highlight rows that contain. Highlight rows with blank cells. Highlight rows with dates between. Highlight top values. Highlight unique values.

Highlight unprotected cells. Highlight values between. Highlight values greater than. Highlight values not between X and Y. Shade alternating groups of n rows. Data validation allow numbers only. Data validation allow text only. Data validation allow uppercase only. Data validation allow weekday only. Data validation date in next 30 days. Data validation date in specific year. Data validation don't exceed total. Data validation exists in list.

Data validation must begin with. Data validation must contain specific text. Data validation must not contain. Data validation must not exist in list. Data validation no punctuation. Data validation number multiple Data validation only dates between. Data validation require unique number.

Data validation specific characters only. Data validation unique values only. Data validation whole percentage only. Data validation with conditional list. Rank function example. Rank if formula. Rank race results. Rank values by month.

Rank with ordinal suffix. Rank without ties. Get decimal part of a number. Get integer part of a number. Get number at place value. Round a number. Round a number down. Round a number down to nearest multiple. Round a number to n significant digits. Round a number to nearest multiple. Round a number up. Round a number up to nearest multiple. Round a number up to next half. Round a price to end in. Round by bundle size. Round price to end in. Round time to nearest 15 minutes.

Round to nearest Round to nearest 5. Add business days to date. Add days exclude certain days of week. Add days to date.

Add decimal hours to time. Add decimal minutes to time. Add months to date. Add workdays no weekends. Add workdays to date custom weekends. Add years to date. Assign points based on late time. Basic timesheet formula with breaks. Calculate date overlap in days. Calculate days open. Calculate days remaining. Calculate expiration date. Calculate number of hours between two times.

IF MOD. Calculate retirement date. Calculate years between dates. Convert date string to date time. Convert date to Julian format. Convert date to month and year. Convert date to text.

Convert decimal hours to Excel time. Convert decimal minutes to Excel time. Convert decimal seconds to Excel time. Convert Excel time to decimal hours. Convert Excel time to decimal minutes. Convert Excel time to decimal seconds.

Convert Excel time to Unix time. Convert text timestamp into time. Convert text to date. Convert time to money. Convert time to time zone. Convert Unix time stamp to Excel date. Count birthdays by month.

Count calls at specific times. Count dates in current month. Count day of week between dates. Count holidays between two dates. Count times in a specific range. Create date range from two dates. Custom weekday abbreviation. Date is same month. Date is same month and year.

Date is workday. Days in month. Days until expiration date. Display the current date. Display the current date and time. Due date by category. Dynamic calendar grid. Dynamic date list. Extract date from a date and time.

Extract time from a date and time. Get age from birthday. Get date from day number. Get day from date. Get day name from date. Get days before a date. Get days between dates. Get days between dates ignoring years. Get days, hours, and minutes between dates. Get days, months, and years between dates. Get earliest and latest project dates. Get first day of month. Get first day of previous month. Get fiscal quarter from date. Get fiscal year from date. Get last day of month. Get last weekday in month.

Get last working day in month. Get Monday of the week. Get month from date. Get month name from date. Get months between dates. Get most recent day of week. Get next day of week. Get next scheduled event. Get nth day of week in month. Get nth day of year. Get percent of year complete. Get project end date. Get project midpoint. Get project start date. Get quarter from date.

Get same date next month. Get same date next year. Get week number from date. Get work hours between dates. Operations software. Connect your favorite apps to HubSpot.

See all integrations. We're committed to your privacy. HubSpot uses the information you provide to us to contact you about our relevant content, products, and services. You may unsubscribe from these communications at any time. For more information, check out our privacy policy. Written by Carly Stec CarlyStec.

Get started with Excel with these 9 free Excel Marketing Templates. For most marketers, trying to organize and analyze spreadsheets in Microsoft Excel can feel like walking into a brick wall over and over again. You're manually replicating columns and scribbling down long-form math on a scrap of paper, all while thinking to yourself, "There has to be a better way to do this. Excel can be tricky that way. On the one hand, it's an exceptionally powerful tool for reporting and analyzing marketing data.

On the other, without the proper training, it's easy to feel like it's working against you. For starters, there are more than a dozen critical formulas Excel can automatically run for you so you're not combing through hundreds of cells with a calculator on your desk. Excel formulas help you identify relationships between values in the cells of your spreadsheet, perform mathematical calculations using those values, and return the resulting value in the cell of your choice.

You might wonder what the "Formulas" tab on the top navigation toolbar in Excel means. In more recent versions of Excel, this horizontal menu -- shown below -- allows you to find and insert Excel formulas into specific cells of your spreadsheet.

The more you use various formulas in Excel, the easier it'll be to remember them and perform them manually. Nonetheless, the suite of icons above is a handy catalog of formulas you can browse and refer back to as you hone your spreadsheet skills. Excel formulas are also called "functions. That browsing window will look like this:. Want a more sorted browsing experience? Use any of the icons we've highlighted inside the long red rectangle in the first screenshot above to find formulas related to a variety of common subjects -- such as finance, logic, and more.

Once you've found the formula that suits your needs, click "Insert Function," as shown in the window above.

Now, let's do a deeper dive into some of the most crucial Excel formulas and how to perform each one in typical situations. To help you use Excel more effectively and save a ton of time , we've compiled a list of essential formulas, keyboard shortcuts, and other small tricks and functions you should know.

If you're using a slightly older version of Excel, the location of each feature mentioned below might be slightly different. The SUM formula in Excel is one of the most basic formulas you can enter into a spreadsheet, allowing you to find the sum or total of two or more values.

The values you enter into the SUM formula can either be actual numbers or equal to the number in a specific cell of your spreadsheet. Keep in mind you can also find the total value of a list of numbers in Excel. Note the colon between both cells, rather than a comma. See how this might look in an Excel spreadsheet for a content marketer, below:.

This allows you to enter a text value into the cell "if" something else in your spreadsheet is true or false. There are times when we want to know how many times a value appears in our spreadsheets. But there are also those times when we want to find the cells that contain those values, and input specific data next to it. We'll go back to Sprung's example for this one.

If we want to award 10 points to everyone who belongs in the Gryffindor house, instead of manually typing in 10's next to each Gryffindor student's name, we'll use the IF-THEN formula to say: If the student is in Gryffindor, then he or she should get ten points.

To convert the resulting decimal value to a percentage, highlight the cell, click the Home tab, and select "Percentage" from the numbers dropdown.

There isn't an Excel "formula" for percentages per se, but Excel makes it easy to convert the value of any cell into a percentage so you're not stuck calculating and reentering the numbers yourself. The basic setting to convert a cell's value into a percentage is under Excel's Home tab. Select this tab, highlight the cell s you'd like to convert to a percentage, and click into the dropdown menu next to Conditional Formatting this menu button might say "General" at first.

Then, select "Percentage" from the list of options that appears. This will convert the value of each cell you've highlighted into a percentage. See this feature below. Simply highlight your cells before or after you perform this formula, and set these cells' format to "Percentage" from the Home tab -- as shown above. Enter a value in the field above to quickly find functions in the list below.

While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy. Please re-enable javascript in your browser settings. Search Excel functions:. Convert currency into words Convert number into words Insert a double quote in a formula Test a string for an alphanumeric value How to Autonumber in Excel Delimit values with ASCII 29 character Creating a custom round function Creating a custom average function that excludes outlyers from the calculation. Share on:.

ROW WS. Returns the position of the first occurrence of a string in another string, starting from the end of the string. Adds a specified number of work days to a date and returns the result as a serial date customizable weekends.

Compatibility: Returns the hypergeometric distribution. IF function. Logical: Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. IFNA function.

IFS function. Logical: Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IMABS function. Engineering: Returns the absolute value modulus of a complex number.

Engineering: Returns the imaginary coefficient of a complex number. Engineering: Returns the argument theta, an angle expressed in radians. Engineering: Returns the complex conjugate of a complex number. IMCOS function. Engineering: Returns the cosine of a complex number. Engineering: Returns the hyperbolic cosine of a complex number. IMCOT function.

Engineering: Returns the cotangent of a complex number. IMCSC function. Engineering: Returns the cosecant of a complex number. Engineering: Returns the hyperbolic cosecant of a complex number. IMDIV function. Engineering: Returns the quotient of two complex numbers. IMEXP function.

Engineering: Returns the exponential of a complex number. IMLN function. Engineering: Returns the natural logarithm of a complex number. IMLOG10 function. Engineering: Returns the base logarithm of a complex number. IMLOG2 function. Engineering: Returns the base-2 logarithm of a complex number.

Engineering: Returns a complex number raised to an integer power. Engineering: Returns the product of complex numbers. Engineering: Returns the real coefficient of a complex number. IMSEC function. Engineering: Returns the secant of a complex number. Engineering: Returns the hyperbolic secant of a complex number.

IMSIN function. Engineering: Returns the sine of a complex number. Engineering: Returns the hyperbolic sine of a complex number. Engineering: Returns the square root of a complex number.

IMSUB function. Engineering: Returns the difference between two complex numbers. IMSUM function. Engineering: Returns the sum of complex numbers. IMTAN function. Engineering: Returns the tangent of a complex number. INDEX function. Lookup and reference: Uses an index to choose a value from a reference or array. Lookup and reference: Returns a reference indicated by a text value. INFO function. Information: Returns information about the current operating environment. INT function.

Math and trigonometry: Rounds a number down to the nearest integer. Statistical: Returns the intercept of the linear regression line. Financial: Returns the interest rate for a fully invested security. IPMT function. Financial: Returns the interest payment for an investment for a given period. IRR function. Financial: Returns the internal rate of return for a series of cash flows. ISERR function. ISNA function. ISODD function. ISREF function. Math and trigonometry: Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.

Date and time: Returns the number of the ISO week number of the year for a given date. ISPMT function. Financial: Calculates the interest paid during a specific period of an investment.

JIS function. Text: Changes half-width single-byte characters within a string to full-width double-byte characters. KURT function. Statistical: Returns the kurtosis of a data set. LARGE function.

Statistical: Returns the k-th largest value in a data set. LCM function. Math and trigonometry: Returns the least common multiple. Text: Returns the leftmost characters from a text value. Text: Returns the number of characters in a text string. LET function. Math and trigonometry: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula. Statistical: Returns the parameters of a linear trend.

LN function. Math and trigonometry: Returns the natural logarithm of a number. LOG function. Math and trigonometry: Returns the logarithm of a number to a specified base. LOG10 function. Math and trigonometry: Returns the base logarithm of a number.

Statistical: Returns the parameters of an exponential trend. Compatibility: Returns the inverse of the lognormal cumulative distribution. Statistical: Returns the cumulative lognormal distribution. Compatibility: Returns the cumulative lognormal distribution.

Statistical: Returns the inverse of the lognormal cumulative distribution. Lookup and reference: Looks up values in a vector or array. LOWER function. MATCH function. Lookup and reference: Looks up values in a reference or array. MAX function. Statistical: Returns the maximum value in a list of arguments. MAXA function. Statistical: Returns the maximum value in a list of arguments, including numbers, text, and logical values.

Statistical: Returns the maximum value among cells specified by a given set of conditions or criteria. Math and trigonometry: Returns the matrix determinant of an array. Statistical: Returns the median of the given numbers.

Text: Returns a specific number of characters from a text string starting at the position you specify. MIN function. Statistical: Returns the minimum value in a list of arguments. Statistical: Returns the minimum value among cells specified by a given set of conditions or criteria. MINA function. Statistical: Returns the smallest value in a list of arguments, including numbers, text, and logical values. Date and time: Converts a serial number to a minute.

Math and trigonometry: Returns the matrix inverse of an array. MIRR function. Financial: Returns the internal rate of return where positive and negative cash flows are financed at different rates. MMULT function. Math and trigonometry: Returns the matrix product of two arrays.

MOD function. Math and trigonometry: Returns the remainder from division. MODE function. Compatibility: Returns the most common value in a data set. MULT function. Statistical: Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.

SNGL function. Statistical: Returns the most common value in a data set. MONTH function. Date and time: Converts a serial number to a month. Math and trigonometry: Returns a number rounded to the desired multiple. Math and trigonometry: Returns the multinomial of a set of numbers.

MUNIT function. Math and trigonometry: Returns the unit matrix or the specified dimension. N function. Information: Returns a value converted to a number. NA function.

Statistical: Returns the negative binomial distribution. Compatibility: Returns the negative binomial distribution. Date and time: Returns the number of whole workdays between two dates. INTL function. Date and time: Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Financial: Returns the annual nominal interest rate. Statistical: Returns the normal cumulative distribution. Compatibility: Returns the normal cumulative distribution.

Statistical: Returns the inverse of the normal cumulative distribution. Compatibility: Returns the inverse of the normal cumulative distribution. Statistical: Returns the standard normal cumulative distribution. Compatibility: Returns the standard normal cumulative distribution. Statistical: Returns the inverse of the standard normal cumulative distribution. Compatibility: Returns the inverse of the standard normal cumulative distribution. NOT function. NOW function.

Date and time: Returns the serial number of the current date and time. NPER function. Financial: Returns the number of periods for an investment. NPV function. Financial: Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.

Text: Converts text to number in a locale-independent manner. Engineering: Converts an octal number to binary. Engineering: Converts an octal number to decimal. Engineering: Converts an octal number to hexadecimal.

ODD function. Math and trigonometry: Rounds a number up to the nearest odd integer. Financial: Returns the yield of a security with an odd first period. Financial: Returns the yield of a security with an odd last period. Lookup and reference: Returns a reference offset from a given reference. OR function. Financial: Returns the number of periods required by an investment to reach a specified value.

Statistical: Returns the Pearson product moment correlation coefficient. EXC function. Statistical: Returns the k-th percentile of values in a range, where k is in the range INC function. Statistical: Returns the k-th percentile of values in a range. Compatibility: Returns the k-th percentile of values in a range. Statistical: Returns the rank of a value in a data set as a percentage Statistical: Returns the percentage rank of a value in a data set. Compatibility: Returns the percentage rank of a value in a data set.

Statistical: Returns the number of permutations for a given number of objects. Statistical: Returns the number of permutations for a given number of objects with repetitions that can be selected from the total objects. PHI function. Statistical: Returns the value of the density function for a standard normal distribution. Text: Extracts the phonetic furigana characters from a text string. PI function.