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

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.
 
M

Mike H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max amount of "IF" statements 2
Nesting if functions 1
Why is my tab key not working properly any more in Excel 2007? 1
multiple cells are often selected when I click in only one cell 1
Sum Result of lookup in excel 2007 4
Compatibility Problem between Excel 2003 and 2007 2
Nesting more than 7 IF statements (Excel 2003) 7
Help with Nested IF Statements 4

Top