User Defined Function vs. Named formula

  • Thread starter Thread starter robert.hatcher
  • Start date Start date
R

robert.hatcher

I have used Named Formulas and am now learning about User Defined
Functions. One thing I found with named formulas is that the naming
conventions around global/local selections. Reading about UDFs makes
me think they might be a better option for a lot of my work.

Any insight as to When to use one over the other will be appreciated.

Thanks
Robert
 
IMO they are different beasts.

A named formula would be used to shorten formulae by including a name rather
than the sub-formula (especially where it is repeated), and to improve
readability/maintainability, as the name would/should be meaningful.

A UDF would be written to provide functionality that Excel does not, or
where it can improve the performance of a formula loaded spreadsheet.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Thanks Bob

Bob said:
IMO they are different beasts.

A named formula would be used to shorten formulae by including a name rather
than the sub-formula (especially where it is repeated), and to improve
readability/maintainability, as the name would/should be meaningful.

A UDF would be written to provide functionality that Excel does not, or
where it can improve the performance of a formula loaded spreadsheet.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
Click to expand...
 
Back
Top