Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 3 down vote favorite

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$31

I can't understand how it works.

share|improve this question
2  
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: office.microsoft.com/en-us/… – MacGyver Mar 1 at 22:38

1 Answer

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.