function question

[alvo23]

Does anyone know what the EVGET function does?

 

[phantom1975]

I didn't find it in Excel or VBA help. Is this from an add-in?

 

[Norie]

Where are you seeing/getting this function?

I can't find it in any of the standard add-ins.

 

[alvo23]

in a spreadsheet sent to me, one of the cell's has this:

=ROUND(EVGET($B$1,$B$2,$B$3,D$2,$B$5,$B$9,D$1,$A47)/100,3)

 

[Norie]

What is checked when you goto Tools>Addins...?

Is there any code in the workbook? It might be a user defined function.

 

[alvo23]

no add ins are checked,
how do i tell if its a user defined function, and if it is, how do i find out what it's doing?

thanks!

 

[Norie]

Open the Visual Basic Editor. (ALT+F11)

In the Project Explorer (top left pane) see if there is a folder called Modules.

If it is a UDF the code for it could reside in there.

 

[Data Bender]

"The EvGet (Get) function retrieves a data value based on one or more specified members." from the following SAP link:

EvGET - SAP Documentation

Apparently, EVGET returns data from an SAP database, similar to an OLAP connection with MS Access.