4 Replies Latest reply on May 24, 2016 7:00 PM by user19752

    I have no training on Filemaker but I'm trying to create a calculation.  Is there anyone who know how to write a calculation that works for the following:

    laurie@charitycompliancesolutions.com

      I have no training on Filemaker but I'm trying to create a calculation.  Is there anyone who knows how to write a calculation that has multiple "If" calculations in it?

      Basically I'm trying to create a calculation that is if the answer to one "if" = "Yes" then I want it to go through the "If's" below and come up with the correct fee.

       

      If (PI_22_NetAssetsFundBallancesEnd < 49999; 25;

      If (PI_22_NetAssetsFundBallancesEnd <249999; 50;

      If (PI_22_NetAssetsFundBallancesEnd <999999; 100;

      If (PI_22_NetAssetsFundBallancesEnd <9999999; 250;

      If (PI_22_NetAssetsFundBallancesEnd <49999999; 750;

      1500

       

      If the answer to one "If" = "No"; "0"