The most common formula errors are syntax errors. Check syntax by simply pressing the button labelled Check Syntax.

Missing or extra parentheses

This is a common mistake when nesting logical statements such as IF(), AND() and OR(). This one is missing a “)”.

This one has an extra ‘)’.

Field does not exist

The best way to avoid this is to simple use the Insert Operator or Insert Field tool. This ensures that they’re not mispelled and that they are available.

Incorrect number of parameters

This is particularly common in functions which take a variable number of parameters. Such as CASE().

Unknown function

This might occur if you misspell a function. Use Insert Function to avoid this error.

Different data types

Compile size and formula length errors 

Formulas are limited to 3,900 characters or 4,000 bytes. This includes spaces, return characters and comments. And they can’t exceed 5,000 bytes when compiled.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s