=VLOOKUP(D7,{0,9000;16,12000;23,18000;31,24000},2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"S S" wrote in message
. uk...
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