2 Replies Latest reply on Jan 31, 2011 12:11 PM by TanaeDeMoulin

    Calculate If Function using a specific date as the "test"

    TanaeDeMoulin

      Title

      Calculate If Function using a specific date as the "test"

      Post

      I am trying to create an If Function, where the date is greater than 01/01/2008, if that is true, I want to calculate an average of 3 pieces of data.  I have used the same function in Excel and it works perfectly.  Is this possible using an If Function in FileMaker or am I to use another function?