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)