Excel formulas don’t have to be ugly.

This post explains what is IFERROR function and how to use the function in Microsoft Excel. The IFERROR function was introduced in Excel as a logical function to handle errors that may occur within ...

The TRANSLATE function in Excel enables you to translate text into over 100 languages, covering a wide range of commonly spoken languages worldwide. This function is particularly useful for creating ...

Have you ever trusted a tool to simplify your work, only to discover it might be quietly leading you astray? That’s exactly the risk you run with Excel’s “Percent Of” function. On the surface, it ...

This amazing new Excel function will make you retire SUMIF forever! In this video, I'll show you Excel's brand new GROUPBY ...

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

Q. I have an Excel spreadsheet that contains errors because some of the numbers that are part of the calculations are blank or zero. Is there a way to have Excel automatically return something instead ...

The Excel GCD function is a Math and Trigonometry function, and its purpose is to return the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that ...

Q. There are formulas that I am repeatedly having to create in my Excel workbook, and there are no built-in functions in Excel that can do these calculations. Is there a quicker way to reuse the same ...

Excel's IF function validates a cell's contents, determining whether it meets criteria that you set. It provides no information beyond what your workbook already contains, but it analyzes the data ...

Excel has received a new function responsible for inserting images directly into cells. The IMAGE function is now available for Office Insiders on Windows, macOS, iOS, and Android. Microsoft has ...

Regardless of whether your Excel spreadsheet contains a little or a lot of data, you may want to have cells that meet certain criteria stand out. Excel lets you set some conditional formatting rules ...