=If Formulas

03/22/18 Edited 12/09/19

Hi!

I am attempting to create an "=If" formula that has 21 "if_then" statements.  When I get to the end my formula enters as "Unparsable."  Is there a limit to criteria in a formula?

Thanks!

Popular Tags:

Comments

  • Hello,

    There is only a limit of 4000 character per cell. You would be warned if this was the case. #Unparsable means that there is a malformed argument. Either you are missing a parenthesis or a comma. 

    If you could paste the formula in this post, I might be able to point out where the issue is. 

    Taylor

Sign In or Register to comment.