View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default Why do people use SUM() unnecessarily?

The only thing worse is:

=+SUM((D19-B19)/B19)

<vbg

Biff

" wrote
in message ...
Someone wrote:
I need a formula that will show percent change from the
pervious month, the one I came up with is =SUM((D19-B19)/B19)


This is just one example of many that use =SUM() unnecessarily.
Presumably =(D19-B19)/B19 is just as good, if not better
performance-wise.

Why is this "screwy" idea so pervasive, namely using SUM() to
bracket any arithmetic expression? Is there a lousy text on the
market that is giving misleading instruction? Is this perhaps a
carryover from requirements of ancient spreadsheet software
(e.g. Visicalc)? (Not as I recall.)

I know: I shouldn't care. But I hate to see people learn poor
programming technique.