Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

How to Use the IF Function in Excel 2007 With Absolute References. Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's ...

When creating formulas and equations on Microsoft Excel, users have the option of inserting multiple functions and conditions into a formula to attain a desired result. This action is often referred ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.

Referencing can become difficult, especially if you’re using structured referencing. Instead, reference a spill range so you can use the hashtag shortcut.

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 ...