#VALUEerrors will denote incorrect formula construction, including bad input type.
#NUMerrors will specifically represent a numeric error in a formula. A
#NUMerror could mean that the input(s) are not in the range of valid metadata. Currently, all formula failures show
#VALUE, which can be an ambiguous Excel error indicator.