This is more a general programming question but often I try to abstract the capabilities of a function by allowing it to take optional parameters that give the function flexibility in how you feed it incoming data.
In order for this to work, I often will be doing evaluations of the parameters, and in particular booleans. Often I'm tempted to create separate functions that will avoid a boolean evaluation for speed purposes, but I realize this might be an unnecessary if booleans are evaluated an order of magnitude faster than other functions.
Consider:
Any thoughts on how fast this is to evaluate vs. other excel functions?
In order for this to work, I often will be doing evaluations of the parameters, and in particular booleans. Often I'm tempted to create separate functions that will avoid a boolean evaluation for speed purposes, but I realize this might be an unnecessary if booleans are evaluated an order of magnitude faster than other functions.
Consider:
Code:
If varBoolean then
'do something
else
'do something
end if
Any thoughts on how fast this is to evaluate vs. other excel functions?