I want to create an "if" statement evaluating two cells. One cell would have three different options. The second cell has a number to be evaluated by if statements. I want the result of the second cells evaluation be put in a third cell. The following formula works perfectly, with one exception: =CONCATENATE(IF(D3="STYLE A",IF(E3<19.735,19.375,IF(E3<22.375,22.375,IF(E3<25.375,25.375)))),IF(D3="SINGLE",IF(E3<22.375,22.375,IF(E3<25.375,25.375))),IF(D3="BAR",IF(E3<12,12,IF(E3<14,14,IF(E3<18,18,IF(E3<26,26,IF(E3<32,32,IF(E3<36,36,IF(E3<42,42))))))))). The result is the true/false to each part of the if statement. I just one the true answer.