| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
It depends on what you are trying to accomplish. Here are a couple
possibilities: =if(a1=2,"Yes ","")&if(a1=3,"you ","")&if(a1=4,"can.","")&if(.............. Or =if(a1=2,3,0)+if(a1=3,4,0)+if(a1=4,5,0)+if(....... ....... -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "Summer Scobell" <Summer wrote in message ... I'm trying to get excel to do a large IF logical function where I turn 14 different lengths each into a two digit code. Is there any way to get past the limit of 7 nested arguments? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running XY chart labeller using a macro's parameters and arguments. | Charts and Charting in Excel | |||
| Something similar to sum() but ignoring error value arguments! | Excel Worksheet Functions | |||
| =COUNTIF How to if 2 or more arguments??? | Excel Worksheet Functions | |||
| How can I nest more than seven functions in MS Excel? | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Hybrid Mode
