|
|
#1
04-28-2011, 08:40 PM
|
|||
|
|||
Nested IFs
The help file says (I believe) that IFs can be nested 64 deep.
That is: =IF(G5>0,average(G5:G9),IF(G6>0,average(G6:G10),.. ... etc. I currently have such a formula/function in my spreadsheet which contains 7 IFs and it works OK. But if I try to add an additional "IF", I get an error. Any ideas? I can send/email an example sheet if need be. Thanks for any help, Jim 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with nested cylinders and labels | pixmanlajunta | PowerPoint | 0 | 01-18-2010 11:25 AM |
| Nested if formulat to merge cells | cristi22 | Excel | 0 | 10-23-2006 08:28 AM |
Nested IFs
Windows 7 64bit 
Office 2003
Threaded Mode