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"

Let(value = PI_22_NetAssetsFundBallancesEnd;Case(value < 49999; 25;value < 249999; 50;value < 999999; 100;value < 9999999; 250;value < 49999999; 750;1500))I don't understand the part about "0" because, if I understand correctly, if the value is greater than or equal to 49999999, the result is 1500.

Clear?