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

[nastech]

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","-"))))

[nastech]

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","-"))))
>
>