2.1.877 Part 1 Section 18.17.7.6, ADDRESS
a. The standard states if row-number or col-number < 1, #NUM! is returned and if ref-type is outside the range 1–4, #NUM! is returned.
-
Office returns #VALUE! in such cases for the function.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
a. The standard states if row-number or col-number < 1, #NUM! is returned and if ref-type is outside the range 1–4, #NUM! is returned.
Office returns #VALUE! in such cases for the function.