Home 
Search 
Today's Posts 
#1




ENTER EXCEL FORMULA WITH MORE THAN 7 NESTED FUNCTIONS
I am entering and IF expression with more than 7 nested functions. Is there
another way to enter formula which would work? =IF(AG6<6,AF6,IF(AG6=6,AF61,IF(AG6=7,AF62,IF(AG6=8,AF63,IF(AG6=9,AF64,IF(AG6=10,AF65,IF(AG6=11,AF66IF(AG6=12,AF67,IF(AG6=13,AF68,IF(AG6=14,AF69,IF(AG614,0)))))))))))) 
#2





#3




Hi Linda,
You can't do that, as you see, but try this formula =IF(AF614,0,IF(AF6<6,AF6,AF6MATCH(AG65,{1,2,3,4,5,6,7,8,9},0)))  HTH  Bob Phillips "Linda Bolton" <Linda wrote in message ... I am entering and IF expression with more than 7 nested functions. Is there another way to enter formula which would work? =IF(AG6<6,AF6,IF(AG6=6,AF61,IF(AG6=7,AF62,IF(AG6=8,AF63,IF(AG6=9,AF64,IF (AG6=10,AF65,IF(AG6=11,AF66IF(AG6=12,AF67,IF(AG6=13,AF68,IF(AG6=14,AF69 ,IF(AG614,0)))))))))))) 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
How do I view the actual numeric value of a formula in Excel 2002.  Excel Worksheet Functions  
Enter Data Into Another Excel File Automatically  Excel Worksheet Functions  
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???  Excel Discussion (Misc queries)  
how to enter a formula using column() function for a range  Excel Worksheet Functions  
Excel 2003  Formula result shows as 0:00  Excel Worksheet Functions 