IF, AND to satisfy IF range

[jj72uk]

Hi,

I'm trying to write the following formula but keep getting an error and I cannot seem to find where:


=IF(Q15<5, 0, if(and(Q15>5,Q15<8,sum(Q15*9.61),if(and(Q15>8,q15<12,sum(q15*13.94),if(and(q15>12,Q15<24,sum(q15*22.96),"")))))))


Can anyone point me in the right direction?

[zbor]

Try this:

=IF(Q15<5,0,Q15*LOOKUP(Q15,{5,8,12},{9.61,13.94,22.96}))