I encountered an XLS file with this formula in some of its cells. I searched the web for information on the formula, but I couldn't find anything. Could you help?
The formula in question is:
=calcs!$E$31:$AH$31I can't understand how it works.
31 Answer
The reason you can't find anything is that there's no such function. As noted in a comment, it looks like calcs is instead the name of a worksheet. You can tell by the exclamation mark after it, which is used when prepending a worksheet name to a cell (or range of cells). A function would require parentheses around its arguments, which the formula doesn't have.
