Re: nested if statements error
From: Ron Rosenfeld (ronrosenfeld_at_nospam.org)
Date: 07/08/04
- Next message: JulieD: "Re: Sumif with multiple criteria"
- Previous message: anonymous_at_discussions.microsoft.com: "formula help"
- In reply to: juhlott: "nested if statements error"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 08 Jul 2004 11:08:18 -0400
On Thu, 8 Jul 2004 07:39:04 -0700, "juhlott"
<anonymous@discussions.microsoft.com> wrote:
>I have 12 nested if statements and I constantly get an
>error at the beginning of the ninth statement. It is not
>255 characters so I am not sure what is wrong. Help!
You have exceeded a limit of Excel. See "Specifications" in HELP.
Excel specifications and limits
Nested levels of functions 7
There is almost certain to be another way of solving your problem. Most likely
one of the lookup functions will do the job.
--ron
- Next message: JulieD: "Re: Sumif with multiple criteria"
- Previous message: anonymous_at_discussions.microsoft.com: "formula help"
- In reply to: juhlott: "nested if statements error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
