I have an Excel formula that I would like to convert over to Filemaker
calculation in my database. When I put in the field names I get an error
on too few parameters.

Any help would be greatly appreciated!


Excel Formula =IF(AND(L5>=0.8),M5,0)


FM Field Name
L5 = Prob
M5 = Dollar
Forecast = (The Calc field) IF(AND(Prob>=0.8),Dollar,0)

In article <o7qdnTdelc7OlG_WnZ2dnUVZ_judnZ2d (AT) earthlink (DOT) com>, John Smith
<john.Smith (AT) example (DOT) net> wrote:

That Excel formula has an unnecessary "And" operator in there since it's
only 'and'ing one parameter. It really only needs to be:

If (L5>=0.8, M5, 0)

which is then the same formula you can use in your FileMaker database,
i.e.
If (Prob>=0.8; Dollar; 0)


Helpfull Harry )

Your Name wrote:

"John Smith" <john.Smith (AT) example (DOT) net> wrote

I meant to add that Excel's formulas use the And operator (as well as the Or
operator) in a rather peculiar way:

And (Test1, Test2, Test3, ...)

whereas FileMaker and most programming languages use a more normal approach:

(Test1) and (Test2) and (Test3) and ...

That might make it easier for you to convert any more Excel formulas.


Helpfull Harry )