Bad IF-statement

[CarrieHoffman02]

I am really new to using the IF-statments in formula, however I believe this instance needs one. I am creating a floor box that could have several different comparments. According to the cut sheet I was given, 1 comparment is 5 3/16", 2 is 8.5" and 3 is 12.5". Could someone please tell me what I have done wrong? 

Carrie

[CoreyDaun · Accepted solution]

You do not have a False statement for the last IF. What happens if '# of Compartments' equals 4? If three is the maximum possible value for # of Compartments, then it should be written like:

if(# of Compartments = 1, 4 3/8", if (# of Compartments = 2, 8 1/2", 12.5"))

This basically means: If # equals 1 then make it 4 3/8", If # equals 2 then 8 1/2", otherwise make it 12 1/2".