Reader Asks: Using The FileMaker Case Function

From Dwayne Wright PMP, PMI-ACP
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

A READER WRITES
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.
Most advice on-line is to use the newer CASE function.
 
Can you help me figure this out?
Thank you… either way!

DWAYNE RESPONDS
I am ruthlessly busy and cannot support things like this as much as I like ... but ... I did give it a quick "first cup of coffee" shot at it. Since the "number of guest" part of the puzzle was linear, I tried the "Choose" function. I don't use it that often but I think the enclosed file might work.  Choose is a neat little function that seems a little odd, at first. It first will perform a test and return a number that is equal to or greater than zero. Then it will follow with a number of expressions that will link to that number. I have written about it before ( click here ).
 
Case(
Number Of Days ≥ 56;Choose ( Number Of Guests ; 0; 10; 8; 7 );
Number Of Days ≥ 29; Choose ( Number Of Guests ; 0; 15; 11; 9.5 );
Choose ( Number Of Guests ; 0; 20; 35; 50; 65; 80 ))