Since you're adding the values, maybe you could use:

IF(Chose="Birkenhead",B70,0) + IF(Chose="Bradford",B123,0) + ...

Then you don't have as many nested if's.



y_not wrote:

I am using a formula which relies on the user selecting an option form a
drop down list. Depending on thier choice the sheet displays information
relative to the selection.

This has worked fine for a while but I have been asked to add two extra
items to the drop down list. The effect of this that Excel reports an
error because (I think) there are too many IF statements.

Does anyone have any idea of how I can get around this, please?

If the formula makes any sense I have added it below: -

=IF(Chose="Birkenhead",B70,IF(Chose="Bradford",B12 3,IF(Chose="Derby",B176,IF(Chose="Leeds",B229,IF(C hose="Rochdale",B282,IF(Chose="Sainsbury's",B335,I F(Chose="Skelmersdale",B388,IF(Chose="Basingstoke" ,B441,'C:\Documents
and
Settings\Desktop\Test\Tracker\[Skelmersdale.xls]Driver'!B8+'C:\Documents
and
Settings\Desktop\Test\Tracker\[Sainsbury''s.xls]Driver'!B8+'C:\Documents
and Settings\Desktop\Test\Tracker\[Rochdale.xls]Driver'!B8+'C:\Documents
and Settings\Desktop\Test\Tracker\[Leeds.xls]Driver'!B8+'C:\Documents
and
Settings\Desktop\Test\Tracker\[Bradford.xls]Driver'!B8+'C:\Documents
and
Settings\Desktop\Test\Tracker\[Birkenhead.xls]Driver'!B8+'C:\Documents
and Settings\Desktop\Test\Tracker\[Derby.xls]Driver'!B8))))))))

The list is of town names, "Chose" is the named cell of the drop down
and "Region" simply totals the data for the eight towns

--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=394172

--

Dave Peterson