I'd just like to put in my 2¢, since I almost always use the asterisk form
of SP due to the way it's used in many of the WBs at our plants.
Depending on the means of data input, it might prove wiser to evaluate your
different usage's before universally changing to the unary form.
A couple of years ago I did what you're thinking of doing, and got *burned*,
due to my lack of properly evaluating how my formulas were being used in the
different departments.
Be advised, that the asterisk form will compute all numbers, in whatever
format they're presented, and will return errors if there are anything
*other* then numbers in the calculating range.
The unary form will simply "go by" these "non-numbers", calculating and
returning values, with *no* warning (error messages), advising that
something might be amiss.
I described my misfortune in this old thread:
http://tinyurl.com/2e4equ
If you're sure that your values are consistent, and their input is beyond
reproach, by all means, switch your formulas.
But with users like mine, I feel much safer using the asterisk!
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rick Rothstein (MVP -
VB)" wrote in
message ...
I agree that in the majority of applications there is no real
perceivable
difference but in "heavy duty" applications every bit of efficiency
helps
no matter where you find it.
I guess my short-sightedness stems from my Excel background...
approximately
15-year break from Excel and, back when I did work with it, my
applications
were all Engineering ones, so I doubt any of them rose anywhere near the
level you are suggesting with the words "heavy duty". I guess if you have
a
few thousand or so of those SUMPRODUCTs strewn about your application, the
few thousandths of a second mount up. I hate you, you know... because of
you, I am going to have to switch from the multiplication syntax (which I
really, really like better) to the comma version... I hate you.<vbg
Rick