=IF(J18<$A$5,$D$4,IF(AND(J18>=$A$5,J18<$A$7),$D$6,
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
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