ExcelBanter - View Single Post

tcek

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.