 Publishers of the world’s most comprehensive and up-to-date Excel tutorials

## Category: Formulas

Search again: ## How to create an auto-updating Calendar Sheet in Excel

In this lesson you’ll create a fully functional calendar in Excel. The calendar showcases the new SEQUENCE dynamic array formula. ## Excel formula to get working days between two dates excluding holidays

This article shows you how to calculate the number of working days between two dates in Excel using the NETWORKDAYS function. ## Applying a unique constraint in Excel

This article shows how to impose a unique constraint in Excel, preventing duplicate items from being accidentally entered. ## Remove dashes from ssn, keep zeros ## Excel IF formulas with multiple arguments?

This article explains the Excel IF function and how to best handle situations where multiple conditions are needed, including a sample workbook. ## Calculating Loan Payment Dates

This article shows how to calculate loan payment dates in Excel, using a formula that can calculate loans of any length and number of periods. ## Excel formula to get number of days in a month

This article will show you how to create an Excel formula that calculates the number of days in the month for any given date. ## A formula or easy way to annualize data based on month

This article shows you the Excel formula to annualize data by month or by any other number of periods in a year. A sample workbook is included. ## Changing dollar signs to GBP in Excel

This article shows you how to change currency symbols in Excel, how to convert from one currency to another and how to get exchange rate data online. ## Using VLOOKUP, if Column 1 is blank, get value from Column 2

This article shows how to create an Excel VLOOKUP formula that extracts data from a different column if the first column it searches is blank. ## Adding “+” between words in Strings

Code numbers such as product codes are common in Excel. When you work with codes like these you often need to join multiple pieces of text (or ‘strings’). ## Calculating the original number after a percentage increase

This article shows you how to use Excel to calculate the original number after a percentage increase – a surprisingly common problem in accounting. ## Convert negative numbers to positive in Excel

This Excel article shows you how to convert negative numbers into positive numbers without affecting existing positive numbers. ## How to hide #N/A errors in Excel

This article explains the #N/A error code in Excel, why it occurs and how to hide it when it appears on your Excel worksheets. ## How to use factorial (!) in Excel

This article shows how to calculate factorials and other combinatorials in Excel, showing how to calculate the probability of winning the lottery. ## An Excel formula to get the week of the month

This article shows you how to create an Excel formula to get the week of month from a date, as well as how to get the week of year from a date. ## Working with HEX values in Excel

This article explains the Hexadecimal counting system and how to work with it in Excel, as well as the four different counting systems supported by Excel. ## VLOOKUP using text strings

How to use VLOOKUP to search for a piece of text and return a matching value. This article also explains what VLOOKUP is and when to use it. ## Separating text and numbers in Excel

This article shows three different ways of separating text and numbers in Excel. You’ll see how to do this using Flash Fill, Text to Columns and formulas. ## Adding VAT to a value in Excel

This article shows how percentages are handled in Excel workbooks and how to add 20% VAT to a value in Excel, along with an example. ## An Excel formula to check if a cell contains some text

Sometimes you need to know whether a cell contains specific, or any text. This article shows how to do this using the SEARCH, ISNUMBER and FIND functions. ## Subtracting percentages in Excel

This article explains how Excel handles percentages and shows you how to subtract a percentage from a number in Excel using two different methods.