Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > Multiple IF Statment not working
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 52
Default 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))))))))
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 506
Default 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))))))))
Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 52
Default Multiple IF Statment not working
Perfecto

Thanks very much

"Ms-Exl-Learner" wrote:

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))))))))
Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 8,651
Default Multiple IF Statment not working
Don't forget that the 7 is a limit on "Nested levels of functions", not just
on nested IF functions. Fortunately, in that formula the COUNT functions
are generally in a different branch of the tree from the extra IF, so it is
not nested to much more deeply.
--
David Biddulph

"Ms-Exl-Learner" wrote in message
...
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))))))))


Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 506
Default Multiple IF Statment not working
Youre Welcome.

--------------------
(Ms-Exl-Learner)
--------------------



"Mark D" wrote:

Perfecto

Thanks very much

"Ms-Exl-Learner" wrote:

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))))))))
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using COUNTIF for multiple text data creating a logic statment Scott Excel Worksheet Functions 12 January 16th 08 12:18 AM
multiple if statment maijiuli Excel Worksheet Functions 2 June 2nd 07 12:02 AM
If statment if its possible. atb Excel Discussion (Misc queries) 2 October 17th 06 05:50 PM
IF Statment across Multiple Sheets jdeer0618 Excel Worksheet Functions 1 May 18th 06 11:20 AM
Multiple IF THEN ELSE statment Mark G Excel Worksheet Functions 5 March 18th 05 08:51 PM


All times are GMT +1. The time now is 08:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement