Try:
Formula: copy to clipboard
=IF(AND( B22 > 1000, B22 < 8820), "FLAMMABLE", "")