User Defined Function vs. Named formula

[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

 

[Bob Phillips]

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)

 

[robert.hatcher]

Thanks Bob

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)