In Microsoft Excel, an EXP function is a Math and Trigonometry function, and its purpose is to return e raised power to the power of a given number. The constant e is the base of the natural ...

If you refer to the same value in an Excel sheet often, treat it as a constant. Anyone who uses Excel, even just a bit, knows how to name a cell or range and then use that name in formulas. It’s ...

Using the IF function with absolute references forces the cell reference inside a formula to remain constant.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

In the October 2001 “Technology Q&A,” we described how to use the dollar symbol ($) in Excel formulas to make formulas constant—so if you copy them to a different cell they won’t automatically change ...