Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
expression length
What is the maximum length that an "IF" function expression. I have an
expression that gives and effor message and I think excel is attempting to truncate it. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
expression length
What formula and what error message
-- Kind regards, Niek Otten Microsoft MVP - Excel "tcek" wrote in message ... What is the maximum length that an "IF" function expression. I have an expression that gives and effor message and I think excel is attempting to truncate it. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
expression length
Before xl 2007, 7 nested ifs' Have a look in the help index for VLOOKUP
-- Don Guillett Microsoft MVP Excel SalesAid Software "tcek" wrote in message ... What is the maximum length that an "IF" function expression. I have an expression that gives and effor message and I think excel is attempting to truncate it. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
expression length
Hi
Which version of Excel? For versions below Xl2007, you can only have 7 levels of nesting. XL2007 allows up to 64 levels of nesting (not to be recommended). Show us your formula, and explain what you are trying to do. There is probably an easier way using Vlookup. -- Regards Roger Govier "tcek" wrote in message ... What is the maximum length that an "IF" function expression. I have an expression that gives and effor message and I think excel is attempting to truncate it. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
expression length
=IF(AND(OR(B15="Unknown",B15="1",B15="2",B15="3"), OR(B17="A",B17="B")),6,IF(AND(OR(B15="4",B15="5"), OR(B17="A",B17="B")),7,IF(AND(OR(B15="6",B15="7",B 15="8",B15="9"),OR(B17="A",B17="B")),8,5)))
I want to add a "C" for B17 with different resulting values for "Unknown", "1", "2", etc in B15. The actual formulat has longer texts for 1, 2, A and B. "Niek Otten" wrote: What formula and what error message -- Kind regards, Niek Otten Microsoft MVP - Excel "tcek" wrote in message ... What is the maximum length that an "IF" function expression. I have an expression that gives and effor message and I think excel is attempting to truncate it. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
expression length
Here are a couple of ideas you can play with to shorten
=LOOKUP(B15,{1,6;3,7;5,9}) 1or 2 = 6, etc =IF(B17<"c",1,2) -- Don Guillett Microsoft MVP Excel SalesAid Software "tcek" wrote in message ... =IF(AND(OR(B15="Unknown",B15="1",B15="2",B15="3"), OR(B17="A",B17="B")),6,IF(AND(OR(B15="4",B15="5"), OR(B17="A",B17="B")),7,IF(AND(OR(B15="6",B15="7",B 15="8",B15="9"),OR(B17="A",B17="B")),8,5))) I want to add a "C" for B17 with different resulting values for "Unknown", "1", "2", etc in B15. The actual formulat has longer texts for 1, 2, A and B. "Niek Otten" wrote: What formula and what error message -- Kind regards, Niek Otten Microsoft MVP - Excel "tcek" wrote in message ... What is the maximum length that an "IF" function expression. I have an expression that gives and effor message and I think excel is attempting to truncate it. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
expression length
Excellent...Thank you much
"Don Guillett" wrote: Here are a couple of ideas you can play with to shorten =LOOKUP(B15,{1,6;3,7;5,9}) 1or 2 = 6, etc =IF(B17<"c",1,2) -- Don Guillett Microsoft MVP Excel SalesAid Software "tcek" wrote in message ... =IF(AND(OR(B15="Unknown",B15="1",B15="2",B15="3"), OR(B17="A",B17="B")),6,IF(AND(OR(B15="4",B15="5"), OR(B17="A",B17="B")),7,IF(AND(OR(B15="6",B15="7",B 15="8",B15="9"),OR(B17="A",B17="B")),8,5))) I want to add a "C" for B17 with different resulting values for "Unknown", "1", "2", etc in B15. The actual formulat has longer texts for 1, 2, A and B. "Niek Otten" wrote: What formula and what error message -- Kind regards, Niek Otten Microsoft MVP - Excel "tcek" wrote in message ... What is the maximum length that an "IF" function expression. I have an expression that gives and effor message and I think excel is attempting to truncate it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation length, Range length | Excel Discussion (Misc queries) | |||
value expression | Excel Worksheet Functions | |||
need help with expression | Excel Discussion (Misc queries) | |||
Expression | New Users to Excel | |||
Expression for Macro - help | Excel Discussion (Misc queries) |