Prev: Pivot Table - Calculated Field
Next: HELP!
From: MORRIPJ on 24 Mar 2010 09:45
In EXCEL 2003 was limited to 8 IF statements (or other functions). Does EXCEL
2007 allow more than 8? Just started using EXCEL 2007 yesterday.
From: Mike H on 24 Mar 2010 09:58
Hi,

You can have up to 64 in 2007 but there is almost always a better way of
doing it than creating a monster formula nested that deep.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"MORRIPJ" wrote:

> In EXCEL 2003 was limited to 8 IF statements (or other functions). Does EXCEL
> 2007 allow more than 8? Just started using EXCEL 2007 yesterday.
 | 
Pages: 1
Prev: Pivot Table - Calculated Field
Next: HELP!