AnsweredAssumed Answered

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:

Question asked by laurie@charitycompliancesolutions.com on May 24, 2016
Latest reply on May 24, 2016 by user19752

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"

Outcomes