Excel - Four returnable values, given two crieteria

Question

I need excel to return one of four possible values given two criteria. The two criteria are:

• Is the value in cell A1 >= to 10 OR A1 < 10 (two possibilities)

and

• Is the value in cell B1 > 35% OR B1 <= 35% (two possibilities)

There are four possible outcomes for these criteria. What kind of formula can I use to handle this situation?

Answer 1

Something like this will work -

=IF(A1<10,IF(B1>.35,"FT","FF"),IF(B1>.35,"TT","TF"))

So first it checks A1 for less than 10, which determines the first letter F/T

Then it checks B1, already having had determined the first letter, to determine the second letter F/T.