'Do most/all Excel functions work on a range?
Do all Excel formulas work properly on a (non-irregular) Range? For example, I was surprised to see that =ABS(range) returns a dynamic array with the ABS function applied to each range value:
Is this the default behavior for most Excel functions? Another function where this doesn't work is something like =DELTA(A1:A2, 1). Unfortunately it doesn't give too much information on the Docs or in Excel-helper, other than saying something like "accepts number".
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|