Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can use IF function more than 7 times in a cell
Excel limits the function IF at 7 times, how can I set IF more than 7 times
in a cell -- wuwu |
#2
|
|||
|
|||
Hi
you can't. But in most cases there're better ways to achieve this. e.g. use a lookup table and vLOOKUP. You may post some more details what you're trrying to evaluate (post your conditions and the desired output or the formula you have tried already) -- Regards Frank Kabel Frankfurt, Germany "wuwu" schrieb im Newsbeitrag ... Excel limits the function IF at 7 times, how can I set IF more than 7 times in a cell -- wuwu |
#3
|
|||
|
|||
Try to re-express the task in terms of a lookup formula with LOOKUP() or VLOOKUP, etc. wuwu Wrote: Excel limits the function IF at 7 times, how can I set IF more than 7 times in a cell -- wuwu -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=277958 |
#4
|
|||
|
|||
Hi
Instead nested IF's you can use: 1. When the result will be numeric =LogicalCondition1*Result1+LogicalCondition2*Resul t2+.. 2. When the result will be text =IF(LogicalCondition1,Result1,"") & IF(LogicalCondition2,Result2,"") & .. 3. VLOOKUP function like adviced by Frank and Aladin. You can use a lookup table (usually it will be on separate sheet), or you use an array as function parameter instead. 4. INDEX function. It'll be especially useful when for some reason you prefer the lookup table in matrix form. 5. A combination of MATCH and CHOOSE functions (it's limited with 24 different choices), like =CHOOSE(MATCH(ValueToSearch,{Value1,Value2,...},0) ,Choice1,Choice2,...) when exact match is searched for, or =CHOOSE(MATCH(ValueToSearch,{Value1,Value2,...},1) ,Choice1,Choice2,...) when the search value must be =Value(n) and <Value(n+1) Choices can be as numeric so texts. 6. A reduced formula like in previous paragraph - when you instead using MATCH use some numeric expression which returns integer values 1 or 2 or ..... To be exact, these values mustn't be integers - the decimal part is simply ignored. =CHOOSE(NumericExpression, Choice1, Choice2, ...) Again, you are limited to 24 differnt choices there. -- Arvi Laanemets (When sending e-mail, use address arvil<Attarkon.ee) "wuwu" wrote in message ... Excel limits the function IF at 7 times, how can I set IF more than 7 times in a cell -- wuwu |
#5
|
|||
|
|||
The '7' limit only applies to nested IFs. If you don't nest you can use
more, but there are almost always better ways to approach such a problem, some of which other have suggested. Cheers "wuwu" wrote in message ... Excel limits the function IF at 7 times, how can I set IF more than 7 times in a cell -- wuwu --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.788 / Virus Database: 533 - Release Date: 1/11/2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
Function to return colour of formatted cell | Excel Worksheet Functions | |||
continuous cell function | Excel Worksheet Functions |