Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF statements
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Better Way to Code IF Statements? | Excel Discussion (Misc queries) | |||
Logical ELSE statements | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions | |||
Macro to find and delete all FALSE statements | Excel Discussion (Misc queries) | |||
If statements | Excel Worksheet Functions |