=IF(F23<=$BT$6,$BZ$6,IF(AND(F23=$BS$7,F23<=$BT$7) ,$BZ$7,IF(AND(F23=$BS$8,F23<=$BT$8),$BZ$8,IF(AND( F23=$BS$9,F23<=$BT$9),$BZ$9,IF(AND(F23=$BS$10,F2 3<=$BT$10),$BZ$10,IF(AND(F23=$BS$11),$BZ$13,"0")) ))))
This is my formula, how do I make the cell read zero if there is no
information in f23