AnsweredAssumed Answered

Help with If/Then formula

Question asked by RickKughen on Apr 29, 2012
Latest reply on Apr 30, 2012 by philmodjunk


Help with If/Then formula



I am new to using Filemaker. I am a baseball card collector and I have managed my baseball card collection in an Excel worksheet for a long time. As you can imagine, that worksheet has gotten unwieldy, so I upgraded to Filemaker Pro 12.

What I am trying to do is this:

1. Each card is assigned a value, such as MINT, VERY GOOD, EXCELLENT, etc.  This condition is chosen from a drop down menu in one of my fields.

2. Each card has a book value based on the card being in perfect condition. I am entering this manually for each card as a dollar amount.

3. I would like for another field to show the book value adjusted by condition of the card. For instance, if a card has a book value of $10 and the card is in VERY GOOD condition, the value would be adjusted accordingly.

In my Excel database, I set up a If/Then function like this:


Is it possible to do something similar in Filemaker? I have tried a variety of different formulas, but have not been able to make it work.

Thank you for your help!

- rick