I added a simple calculator, just add, substract, multiply and divide to a data base. I am using Evaluate to provide the answer to a calculation.

Using a standard calculator with this formula 120 + 100 + 80 * 4 * 3 I get the desired result of 3600

But using the Filemaker "Evaluate" the result is 540

What do I need to do to get the same result as a standard calculator?

Thanks!

But 540 is the correct result

Multiply before add is the correct order of precedence.

80 * 4 = 320

+ 100 = 420

+ 12 = 540

If your calculator gave you a different result, it's in error, not FileMaker.