| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple IF Statment not working
Morning all
I thought the following would be quite simple but I am having trouble with it. Only the first part of the forumla appears to be working (if g4 = all then the value I want comes up), howerver if I enter any of the others I get ''FALSE'' appear Any ideas? Also if anyone can additionally help me I need to add 1 more IF to this forumla but it wont let me as I would then have more than 7 functions. So would anyone have an idea how to reduce this forumla ? Thanks in advance =IF(G4="All",COUNT('NA Actuals & Base Info 2009 $'!C3:C36,'EU Actuals & Base info 2009 ‚¬'!C9:C48,'EU Actuals & Base info 2009 ‚¬'!C59:C73,IF(G4="London",COUNT('EU Actuals & Base info 2009 ‚¬'!C22:C48,IF(G4="Stuttgart",COUNT('EU Actuals & Base info 2009 ‚¬'!C59:C73,IF(G4="Geneva",COUNT('EU Actuals & Base info 2009 ‚¬'!C9:C21)))))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using COUNTIF for multiple text data creating a logic statment | Excel Worksheet Functions | |||
| multiple if statment | Excel Worksheet Functions | |||
| If statment if its possible. | Excel Discussion (Misc queries) | |||
| IF Statment across Multiple Sheets | Excel Worksheet Functions | |||
| Multiple IF THEN ELSE statment | Excel Worksheet Functions | |||
![Mark D[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
