find the defination of spreadsheet function

[masds]

How can I find the defination for a spreadsheet function? Thanks

 

[kpetursson]

Did you try the help menu in Excel?
or possibly Google?

Kevin Petursson

 

[bluedragon2]

also, if you hit the function button, it will bring up a list of all functions. Choose one, and it will explain the elements of the function.

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[masds]

Thanks, I mean user defined function, somebody defined functions for calculate the value for a cell, I can't find the defination.

 

[SkipVought]

You're probably out of luck!

Post the macro code and maybe someone can figger it out for you.

Skip,
[sub]
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart! [/sub]

 

[01Patrik]

I might be way of, but you're not looking for the VB editor, are you? Press [Alt] + [F11]. Doubleklick the module in the workbook that contains your function.

The VB code is displayed in there - select a line early in the code of your function, press [F9]. Toggle back to excel, press [F9] again - this will recalculate, and the break in the code (inserted by [F9]) will stop the execution of the code. Use [F8] to follow the calculation step-by-step.

It ain't as good as documentation, but it might help you to understand the function.

...or you can simply post the code here, as Skip wisely suggested...

// Patrik
______________________________

To the optimist, the glass is half full. To the pessimist, the glass is half empty. To the IT Professional, the glass is twice as big as it needs to be.