1. Help center
  2. Community
  3. Community - Users Help
Answered

Passing 'True' or 'False' causes function to return an error.

Avatar
Mohamad
Follow
0

Each time I try to set the argument "optimization" to value True, it returns an error value on every single cell. This happened with TESMTH, LESMTH, SEMSTH and DESMTH functions, how can i fix this?

Comments

1 comment
Sort by Date Votes
  • Avatar
    Mohamad

    Yes, I have seen this on non-English excel version. You'd need to use the corresponding locale (e.g. Spanish, German, etc.) word for 'True' and  'False' as defined in Excel for your language.

    Alternatively, you can simply type "1" for true and "0" for false.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post