UDF Dependent Ranges

[MikeMcCollister]

I have some user defined functions (UDFs) that I want to add some range dependencies to. This is so that I don’t have to make them volatile any more and will make calculations faster.

The current UDFs have either one or two arguments as shown here:

=BudgetLineItemTotal(B24)
=NthItemInMonthCredit(A6, B6)

By adding the dependent range, in this case the table named “MainChecking”, should I make the dependent range the first or last argument of the UDFs?

Dependent range as first parameter:

=BudgetLineItemTotal(MainChecking, B24)
=NthItemInMonthCredit(MainChecking, A6, B6)

Dependent range as last parameter:

=BudgetLineItemTotal(B24, MainChecking)
=NthItemInMonthCredit(A6, B6, MainChecking)

Basically, are there any logical arguments on which one to pick or is this just a big/little endian argument?

Thanks,

Mike

 

[Fluff]

Not sure it makes any difference. Personally I'd put the range as the 1st argument followed by the criteria, simply because that's how Xl functions tend to be laid out.

 

[MikeMcCollister]

Not sure it makes any difference. Personally I'd put the range as the 1st argument followed by the criteria, simply because that's how Xl functions tend to be laid out.

Fluff,

Thanks. Good argument to put it first.

Mike

 

[Fluff]

You're welcome & thanks for the feedback.