If you have multiple criteria in your formula, you can use nested IF statements. Take a look at some of the default formula columns that use nested IF statements! That’s a great way to learn and understand what’s going on.
Some good examples in the Deals module are the Age Tier and Amount Tier formulas.