|
| 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
March 24th, 2010, 01:45 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
March 24th, 2010, 01:58 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
