Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

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

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.