oops, missed a "-" dash, in this formula:

=IF(OR(S9=".",CP9={"",0},CQ9={"","n/a"}),"",
IF(CP9=IF(CP9<CQ9,CQ9,CR9),IF($AK$2="u","U",IF($ AK$2="d","-","D")),"-"))

"Franz Verga" wrote:

nastech wrote:
Trying to see how to make separations in formula / find way to
"result" use of operators for an "IF", i.e.:

not working
=IF((CP9)IF($AK$2="u",,<)IF(CP9<CQ9,CQ9,CR9),"U" ,"-")

would be trying to get: CP9CQ9
will cut size of formula in half... thanks


I don't know if I well understand, but try this:

=IF($AK$2="u",CP9IF(CP9<CQ9,CQ9,CR9),CP9<IF(CP9< CQ9,CQ9,CR9))


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy