Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Limit on number of conditions?
Using Excel 2002, I'm looking for help with creating an if, then formula. I
have 10 conditions to check but it appears that formula won't allow me to enter more than 7. Any suggestions? |
#2
|
|||
|
|||
hard to tell what might work, since you don't give much description.
Conditionals with more than a few conditions can nearly always be simplified (and made easier to maintain!) using either calculations or lookups. OTOH, you may be able to use the technique he http://cpearson.com/excel/nested.htm In article , Amy F. <Amy wrote: Using Excel 2002, I'm looking for help with creating an if, then formula. I have 10 conditions to check but it appears that formula won't allow me to enter more than 7. Any suggestions? |
#3
|
|||
|
|||
7 is the max. You haven't really given enough info, but often people use nested IFs when VLookup would work better, so look in Help for that function. -- Lilliabeth ------------------------------------------------------------------------ Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741 View this thread: http://www.excelforum.com/showthread...hreadid=475068 |
#4
|
|||
|
|||
Thanks to you both - I was asking for someone else, so sorry for the limited
info. You answered it, though! "Lilliabeth" wrote: 7 is the max. You haven't really given enough info, but often people use nested IFs when VLookup would work better, so look in Help for that function. -- Lilliabeth ------------------------------------------------------------------------ Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741 View this thread: http://www.excelforum.com/showthread...hreadid=475068 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Master invoice number | Excel Worksheet Functions | |||
Limit to the number of items in a cell | Excel Worksheet Functions | |||
Is there a limit to the number of worksheets in an excel file? | Excel Discussion (Misc queries) | |||
How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions |