| Home |
| Search |
| Today's Posts |
|
#1
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| office 2007 and old office 2003 excel files | Excel Discussion (Misc queries) | |||
| Opening Office 2003 excel file in Office Excel 2007 | Excel Discussion (Misc queries) | |||
| Opening an Office 2007 Excel file in Office 2003 | Excel Discussion (Misc queries) | |||
| Migrating Office XP EXCEL files to Office 2007 | Setting up and Configuration of Excel | |||
Linear Mode
