The Excel Not function is a built-in Logical function in Excel, and its purpose is to reverse the logic of its argument. Learn how to use it.

Excel's logical functions test whether a statement or data is true or false, before enabling the program to carry out an action based on the result. They are useful for analyzing data, automating ...

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

How to Use Trig Functions in Excel. Excel has built-in functions for sine and cosine, the two core trigonometric functions, and for hyperbolic sine and hyperbolic cosine, their hyperbolic ...

How to use the new TEXTSPLIT() function in Microsoft Excel Your email has been sent Working with strings in Microsoft Excel is common, whether you’re parsing, concatenating or returning a ...

How to Use the COUNT Function The COUNT function in Excel is one of the most basic of the five functions. Use it to count the number of cells containing values, which is handy for seeing the number of ...

This article will explain how to use the conditional functions IF, AND, OR and NOT on Microsoft Excel. Each of these functions can be used as part of a formula in a cell to compare data samples in any ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

If you want to learn how to use IF and VLOOKUP nested functions in Excel, you’ve come to the right place. The IF and VLOOKUP nested functions are two of the most powerful functions in Excel used by ...

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.