While trying to find a solution to a problem I'm having with a FMP file I'm writing, I came across an article by you regarding FMP's CASE function. I am not at a developer, just a regular joe trying to learn and develop a couple of small files, not at all well versed in the intricacies of building a sophisticated DB.

Would help me solve my dilemma? I'd be appreciative if you would I've studied and researched and fought endlessly to figure out why my formula won't work. Probably a simple fix but one that is eluding me.

I'm using FMP 9 and trying to incorporate the CASE function as shown below.

Case(
Number of Days <28 and Number of Guests = 1; 20;
Number of Days <28 and Number of Guests = 2; 35;
Number of Days <28 and Number of Guests = 3; 50;
Number of Days <28 and Number of Guests = 4; 65;
Number of Days <28 and Number of Guests = 5; 80;
0)
+
Case(
Number of Days   ≥ 42  < 56 and Number of Guests = 1; 15;
Number of Days   ≥ 42  < 56 and Number of Guests = 2; 11;
Number of Days   ≥ 42  < 56 and Number of Guests = 3; 9.5;
0)
+
Case(
Number of Days   ≥ 56 and Number of Guests = 1; 10;
Number of Days   ≥ 56 and Number of Guests = 2; 8;
Number of Days   ≥ 56 and Number of Guests = 3; 7;
0)

I've attempted to use IF statements but failed there as well.