4 Replies Latest reply on Jun 17, 2013 3:22 PM by pbartel

    Logical Function - how to?!

    pbartel

      I'm not very good at FileMaker, having been using it only for about a year and it isn't my primary job responsibility. I'm trying to learn from manuals and books as I go.

      However, I have one thing that I need help with, that I just haven't been able to figure out on my own. Hoping someone can point me in the right direction! You've all be helpful in the past with suggestions on the manuals / books to buy, so hoping you can help further.

       

      I need to automatically choose the LOWEST of three calculations to be the final invoiced amount. I had it set up last year using an IF() Function as we only had two calculations to choose from. I now have to add a third and I don't know how to adjust the calculation to accommodate this third option.

       

      Help?!