IF AND formula help

[ejenks1]

I'm attempting to use an IF AND formula to populate cells with the below text values, can someone help please? I have used the following IF formula to give me the first text value but I'm struggling to complete the rest of the formula - =IF(A2<0,"Breached").

Negative value = "Breached"
0-7 = "0-7 days"
7-14 = "7-14 days"

Thanks in advance.

 

[jasonb75]

Which bracket should 7 days fall into? 0-7 or 7-14? It can't be in both.

 

[rpaulson]

=IF(A2<0,"Breached",IF(A2<8,"0-7 Days",IF(A2<15,"7-14 Days","")))

 

[ejenks1]

Thank you, both.

 

[jasonb75]

Looks like you've accepted the formula offered, but does it do exactly what you want?

Anyone can provide an answer but the one provided here may not necessarily be correct. I asked for clarification on an anomaly that I noticed in your question in order to provide the correct answer, while the answer provided makes an assumption that may be wrong.