The basis of this formula is to work out room size and depending on the area
allocate a suitable sized air conditioning unit ....

In cells D7 to D10 I will have a figure between 0-45 (sq metres)

In cells E7-E10 I require an answer based on D cells

if answer between 0-15 then show 9000
if answer between 16-22 then show 12000
if answer between 23-30 then show 18000
if answer 31+ then show 24000

help appreciated for the formula to go into Cells E7-E10
thanks