Embedding operators, IF(x="up",,<)IF..
 

Hi, have a long formula that is double long for having to repeat for up, or
down conditions. If it is possible to embed the operators <, I can cut
a formula in half / add other conditions: running out of IF's. thanks

basically have / need fix for: (receives an error)
=
IF(IF($M$5="L",M9,IF($M$5="H",N9),IF($M$2="u",,<)
IF($M$5="L",M9,IF($M$5="H",N9))),
IF($M$2="u","U",IF($M$2="d","D")),"-")))
long verson of formula is: (works but double of everything)


Long version that works now, but need to add more variables:

=IF(OR(R9=".",CK9={"",0,"n/a"}),"",IF(AND(E9<"x",OR(BR9={"",0})),"X",

IF(AND($AE$2="u",IF($AS$7="L",DM9,IF($AS$7="M",DN9 ,DO9)
IF($AU$7="M",DN9,IF($AU$7="H",DO9,IF($AU$7="5",BX9 ,BY9))))),"U",

IF(AND($AE$2="d",IF($AS$7="L",DM9,IF($AS$7="M",DN9 ,DO9)<
IF($AU$7="M",DN9,IF($AU$7="H",DO9,BX9)))),"D","-"))))

Embedding operators, IF(x="up",,<)IF..
 

p.s.: noticed 1 mistake in long formula: needs 2 parenthesis before
greater-than / less-than signs, instead of 1.

"nastech" wrote:

Hi, have a long formula that is double long for having to repeat for up, or
down conditions. If it is possible to embed the operators <, I can cut
a formula in half / add other conditions: running out of IF's. thanks

basically have / need fix for: (receives an error)
=
IF(IF($M$5="L",M9,IF($M$5="H",N9),IF($M$2="u",,<)
IF($M$5="L",M9,IF($M$5="H",N9))),
IF($M$2="u","U",IF($M$2="d","D")),"-")))
long verson of formula is: (works but double of everything)


Long version that works now, but need to add more variables:

=IF(OR(R9=".",CK9={"",0,"n/a"}),"",IF(AND(E9<"x",OR(BR9={"",0})),"X",

IF(AND($AE$2="u",IF($AS$7="L",DM9,IF($AS$7="M",DN9 ,DO9)
IF($AU$7="M",DN9,IF($AU$7="H",DO9,IF($AU$7="5",BX9 ,BY9))))),"U",

IF(AND($AE$2="d",IF($AS$7="L",DM9,IF($AS$7="M",DN9 ,DO9)<
IF($AU$7="M",DN9,IF($AU$7="H",DO9,BX9)))),"D","-"))))