How to compare two columns in Excel

How to compare two columns in Excel

Comparing the data in two different columns is a frequently used method in data analysis. In Excel, you can compare using formulas or highlighting. In this guide, we’re going to show you how to compare two columns in Excel using these two methods.Compare two columns...
Function: IFERROR

Function: IFERROR

The IFERROR function evaluates a formula and returns a specified value if the formula generates an error. Otherwise, the function returns the result of the formula. In this guide, we’re going to show you how to use the IFERROR function and also go over some tips and...
How to wrap text in Excel

How to wrap text in Excel

By default, Excel will cut off the characters that don’t fit into a certain space. An alternative approach is wrapping the text to fully display it by increasing the cell height. In this guide, we’re going to show you how to wrap text in Excel. These methods...
Function: TEXT

Function: TEXT

Excel TEXT function helps apply a certain formatting to a numeric value. You can think this function as an alternative to number formatting. In this guide, we’re going to show you how to use the TEXT function and also go over some tips and error handling...
How to use format painter in Excel

How to use format painter in Excel

The Format Painter is the life saver when you need to copy only the formatting settings from one section to the other in your spreadsheet. In this guide, we’re going to show you how to use format painter in Excel. The best part is, this feature is supported by pretty...
Function: MROUND

Function: MROUND

The MROUND function rounds a number to the nearest multiple of a specified number. In this guide, we’re going to show you how to use the MROUND function and also throw in some tips and error handling methods.Supported versionsAll versionsSyntax...
Function: ROUNDDOWN

Function: ROUNDDOWN

The ROUNDDOWN function rounds down a number to a specified number of digits. In this guide, we’re going to show you how to use the ROUNDDOWN function and also throw in some tips and error handling methods.Supported versionsAll versionsSyntax...
Function: ROUNDUP

Function: ROUNDUP

The ROUNDUP function rounds up a number to a specified number of digits or decimals. In this guide, we’re going to show you how to use the ROUNDUP function and also throw in some tips and error handling methods.Supported versionsAll versionsSyntax...
Function: ROUND

Function: ROUND

The ROUND function allows you to manage the decimal portion of a numeric value. It rounds a number to a specified number of digits. In this guide, we’re going to show you how to use the ROUND function and also throw in some tips and error handling methods.Supported...