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".
Corey D. ──────────────────────────────────────────────────────────────────────⁞|⁞ Please use .Accept as Solution and Give Kudos as appropriate to further enhance these forums. Thank you!