Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:


I can't understand how it works.

share|improve this question
Looks like there's a worksheet called calcs. Maybe a hidden one? This formula then is just specifying a range of cells on that worksheet. – jozzas Oct 4 '12 at 6:51
You're right! I just found it. Thank you so much! – Ranbir Oct 4 '12 at 6:58
You must have downloaded this file:… – MacGyver Mar 1 '13 at 22:38
up vote 2 down vote accepted

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.

share|improve this answer
I understand. As jozzas pointed out, 'calcs' turned out to be a hidden worksheet. Thanks for your help. – Ranbir Oct 4 '12 at 7:10

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .