Help please

I have a problem, which I have partly sorted, but cannot get any
further.

I need a function that will check the destination (table below,
although it doesn't view very well - sorry!), and then the length. So,
if the destination says Scotland, and it is less than 13861 mm in
length, the answer needs to be 0, if it is Scotland and the length is
between 13861 and 18288, the answer needs to be 80, and if it is
Scotland and the length is more than 18288, the answer is 160.

There are about 20 destinations and the destination can appear in any
position within the table, so I need a formula which will be able to do
this

I was able to do the first two successfully, but when I try to add the
third on I get an error.

The first two look like this

=IF(AND(A36="scotland",C36<13861),0,IF(AND(A36="sc otland",C3613861,C36<18289),80,IF(AND(A36="scotla nd",C3618289),160,IF(AND(A36="Cumbria",C36<13861) ,0,IF(AND(A36="Cumbria",C3613861,C36<18289),60,IF (AND(A36="Cumbria",C3618289),120))))))

Maybe it isn't possible, or I am doing it incorrectly. Any help would
be really appreciated

Thank you very much
Lynne


20% 40%
Destination Basic 13861mm to 18288mm 18289mm & over

Scotland 400 80 160
Cumbria 300 60 120
North-East 250 50 100
North-West 250 50 100
S.Yorks & Humber 150 30 60
E.Mids & Central 250 50 100
North Wales 300 60 120
East Anglia 350 70 140
W.Mids & Staffs 300 60 120
London & North 300 60 120
Ctrl London & South 350 70 140
Gloucs & S.Wales 350 70 140
South East & Coast 400 80 160
South West 400 80 160
W.Yorks & Lincs 200 40 80
Notts & Derbys 200 40 80


--
Lynneth
------------------------------------------------------------------------
Lynneth's Profile: http://www.excelforum.com/member.php...o&userid=26102
View this thread: http://www.excelforum.com/showthread...hreadid=508368