In new Office 2007 EXCEL, can more the 8 IF statements be used?

  • Thread starter Thread starter MORRIPJ
  • Start date Start date
M

MORRIPJ

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.
 
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.
 
Back
Top