Math Formulas in a Field

[nono]

Hi, I would like to say that I only have 2 days playing around with FM, and this is my situation.

I want to know if there is a way that i can type in a field a formula like this =(8*2)+2+2.5+10 and get the result either in the same field or another field to be used in a "Qty total field" for a Square Feet count.

Te reason for this is that we walk the site with a notebook taking notes of how many SqFt the workers did on a week to generate their payroll, I have this table setup in Excel with VLOOKUP for Price per Unit and everything, thanks to this forum i already have tat part of my payroll working (using an invoice based solution), but the part that I want to avoid is taking the notebook doing all the math in a calculator and then type it in File Maker, i would prefer to type directly in file maker and get a result, I know file maker is not a Spreadsheet solution but any guidance would be helpful.

Thanks in advance for any tips or suggestions

[comment]

Check out the Evaluate() function.

[nono]

Thanks a lot, thta's what i was looking for