FileMaker Pro Formula Operators

If you chose to use your own Formulas for pricing moulding or matboard , then you will need to familiarize yourself with Operators, or Formula calculation symbols used by FileMaker Pro.

  • An operator is a symbol or instruction that manipulates expressions in a pricing Formula.

  • For example, the plus (+) operator tells FileMaker Pro to add one expression to another.

  • You can use these operators to create flexible pricing formulas.

Reference: Keyboard Symbols Useful for Formulas

FileMaker Pro Math Operators

Symbol

Name

Definition

+

Plus

Adds two values

-

Minus

Subtracts the second value from the first

*

Multiply

Multiples each value

/

Divide

Divides the first value by the second

()

Precedence

Tells FileMaker Pro to evaluate the expression first

FileMaker Pro Comparison Operators

Symbol

Name

Definition

=

Equals

True if the items are equal

>

Greater Than

True if the value on the left exceeds that on the right

<

Less Than

True if the value on the left is less than the value on the right

>=

Greater Than or Equal To

True if the value on the left is greater than or equal to the value on the right

<=

Less Than or Equal To

True if the value on the left is less than or equal to the value on the right

FIleMaker Pro Logical Operators

Symbol

Name

Definition

AND

and

True only if both items are true

OR

or

True if either item is true

XOR

"this or that"

True if either of the expressions (but not both) is true

NOT

"switch"

Changes the value from False to True or from True to False

FileMaker Pro Text Operators

Symbol

Name

Definition

"   "

text constant

Marks the beginning and end of characters to be considered as text (and not operators, fields or functions)

\

backslash

Identifies that an operator character will be used as a character instead of an operator.

&

concatenate

Appends the text string on the right to end of the text string on the left.

 

© 2023 Adatasol, Inc.