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've been tasked with making changes to an Excel 2010 spreadsheet I know little about. I was pretty good with Excel about a decade ago, but I'm not really sure how to look-up the definitions of particular formulas I see used in cells.

For instance, in one cell I see what I assume is a function call =CEMPRICE!$L$19, I assume this is a call to function CEMPRICE with the contents of cell L19.

Where do I find the definition of CEMPRICE and how it works?

share|improve this question
5  
That is not a function call, that is a call to the worksheet CEMPRICE (it would not be a valid statement otherwise). Check if your workbook has any hidden worksheets. If it was a function call, it would appear as =CEMPRICE($L$19) with parentheses. A name followed by an exclamation mark is a sheet reference. – Breakthrough Jun 27 '11 at 18:45
    
Good call, thanks! – Mark Rogers Jun 27 '11 at 18:48
up vote 7 down vote accepted

In the example you give, CEMPRICE is a sheet reference, so you would have a sheet named "CEMPRICE" (look on the sheet tabs).

You can call up help to look at a built-in function definition, by hitting F1, or using the menu.

For User-defined functions (macros, UDFs) you'll have to go to the VBA editor, the easy way is hitting Alt-F11.

share|improve this answer

In the help search bar in the upper-left corner of the Excel window, type CEMPRICE and see what MS says about the function.

Or google "excel function CEMPRICE". I did this, however, and it didn't return any relevant results, so this is either a custom function defined in the VBA/macros for this sheet, or it's not a function.

share|improve this answer
    
What's with the vote down? – music2myear Jun 27 '11 at 21:42
2  
@musci2myear it is a sheetname as was noted above by a couple people and someone probably thought the ! in the formula should make that obvious, but I agree the downvoter explaining would have been nice, especially since it would help others to understand – datatoo Jun 27 '11 at 21:58

You must log in to answer this question.

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