Multiple IF Statment not working
Try this€¦
=IF(G4="ALL",COUNT('[NA Actuals & Base Info 2009 $.xls]NA Actuals & Base
Info 2009'!$C$3:$C$36)+COUNT('EU Actuals & Base info 2009
‚¬'!C9:C48)+COUNT('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),""))))
Only 4 If statements are there in the above formula so you can add another 3
more If statements on it€¦
If this post helps, Click Yes!
--------------------
(Ms-Exl-Learner)
--------------------
"Mark D" wrote:
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))))))))
|