Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

4
  • \$\begingroup\$ You could save 4 bytes if you defined a single-letter range name (e.g. A) and set that as your input. \$\endgroup\$ Commented Apr 24, 2019 at 18:54
  • \$\begingroup\$ @i_saw_drones - I think that is disallowed by standard I/O rules: here's a link to the meta answer that would apply to that method; it's currently at -36 votes. \$\endgroup\$ Commented Apr 24, 2019 at 20:17
  • \$\begingroup\$ Apologies I hadn't seen that post, although thinking about it, isn't A1 also a "variable" since it contains the input value? :) \$\endgroup\$ Commented Apr 24, 2019 at 23:05
  • 1
    \$\begingroup\$ I would feel that way if I were doing anything special with the fact that it's A1 specifically, like if I relied somehow on its ROW(_) being 1. As is, though, it's just the most natural way of providing an Excel function with an arbitrary input. \$\endgroup\$ Commented Apr 25, 2019 at 17:03