Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hi people views once what I received: | Excel Worksheet Functions | |||
Hi people views once what I received: | Excel Discussion (Misc queries) | |||
Finding people born in a given month or after a given year | Excel Worksheet Functions | |||
Makeing People Save As | Excel Discussion (Misc queries) | |||
Multiple people accessing an Excel file from a server at once. | Excel Discussion (Misc queries) |