Hi,

Am Mon, 23 Sep 2013 12:17:41 +0100 schrieb shrimpy80:

Less than 150 = 0
Between 150 and 199 = £85 payable
Between 200 and 259 = £270 payable
More than 260 = £400 payable

try:
=VLOOKUP(A1,{0,0;150,85;200,270;260,400},2,1)

Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2