Here is the forumla that I've written, can anyone please assist.

=IF(H27<=4,D27*0%,IF(H27>=5<=9,D27*3%,IF(H27>=10<=14,D27*4%,IF(H27>=15<=19,D27*6%,IF(H27>=20<=24,D27*7%,IF(H27>=25,D27*8%))))))

This forumla is returning FALSE into the cell.

Info for the cells

H27=15, D27=$28,912.00 - so the calculation should be calculating that H27 being 15, should take the $28,912.00 and multiply that figure by 6%.

I hope I've been clear enough on my example.

Thanks in advance for any help.

Tami