IF(AND(J18>=$A$7,J18<$A$9),$D$8,IF(AND(J18>=$A$9,J18<$A$11),$D$10,

IF(AND(J18>=$A$11,J18<$A$13),$D$12,IF(AND(J18>=$A$13,J18<!$A$15),$D$14,

IF(AND(J18>=$A$15,J18<$A$17),$D$16,IF(AND(J18>=$A$17,J18<$A$19),$D$18,

IF(AND(J18>=$A$19,J18<$A$21),$D$20,IF(AND(J18>=$A$21,J18<$A$23),$D$22))))))))))

I want to replace the first IF of this formula:

=IF(J18<$A$5,$D$4,

with,

IF(AND(J18>=$A$3,J18<$A$5),$D$4,

but when I do I seem to get a formula error. I also want "--" to be returned if none of the conditions are met. Can anyone help with the syntax? Thanks.

Dan