If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
In new Office 2007 EXCEL, can more the 8 IF statements be used?
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. |
#2
|
|||
|
|||
In new Office 2007 EXCEL, can more the 8 IF statements be used?
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. |
Thread Tools | |
Display Modes | |
|
|