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.

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.

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.

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.

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.

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.

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.