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@earthlink.com>, John Smith
<john.Smith@example.net> wrote:

> 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)

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  :o)

Your Name wrote:
> In article <o7qdnTdelc7OlG_WnZ2dnUVZ_judnZ2d@earthlink.com>, John Smith
> <john.Smith@example.net> wrote:
> 
>> 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)
> 
> 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  :o)
Thanks Harry!

"John Smith" <john.Smith@example.net> wrote in message
news:jamdnYY4e8fgOGvWnZ2dnUVZ_sKdnZ2d@earthlink.com...
> Your Name wrote:
> > In article <o7qdnTdelc7OlG_WnZ2dnUVZ_judnZ2d@earthlink.com>, John Smith
> > <john.Smith@example.net> wrote:
> >
> >> 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)
> >
> > 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)
>
> Thanks Harry!

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  :o)