=If Formulas

03/22/18 Edited 12/09/19


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?


Popular Tags:


  • 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. 


Sign In or Register to comment.