COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Help with converting Excel formula to FM Calc

• Follow

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

```
 0
Reply your.name2 (344) 5/18/2010 4:13:08 AM

```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!
```
 0

```"John Smith" <john.Smith@example.net> wrote in message
> > 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.

```
 0
Reply your.name2 (344) 5/21/2010 9:43:24 PM

3 Replies
97 Views

Similiar Articles:

7/22/2012 12:24:31 AM