Why do I get the #VALUE error?

If the functions return a #VALUE error, it's most likely due to either of these:

  • Forgetting to give a value for some required parameter
  • The value of a parameter is in the wrong format (for example, a text parameter not having quotation marks around it)

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.