excel - IF Function with 3 conditions and outcomes

Question

I'm looking to create a formula with 3 conditions. It is currently only working with 2 conditions. Here's what I'm looking for:

A1 has a number

If the number is >15 then I want it to show Text 1

If the number is between 10 and 15, then I want it to show Text 2

If the number is between 5 and 10, then I want it to show Text 3

If the number is lower than 5, I don't want anything

Anybody got an idea?

Answer 1

Use the IF function:

=IF(A1 > 15, "Text 1", IF(A1 >= 10, "Text 2", IF(A1 >= 5, "Text 3", "")))

Note that the nature of the IF function as used above necessitates also having a value should the value of A1 be less than 5. In this case, I just use empty string, per your updated requirements.