=If Formulas

diana.blaschke28871

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!

Taylor F

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