Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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","-")))) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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","-")))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedding IF: depends on result.. | Excel Discussion (Misc queries) | |||
Can logical operators be used within Conditional Formatting? | Excel Discussion (Misc queries) | |||
embedding worksheet cells in another worksheet | Excel Discussion (Misc queries) | |||
Operators With Times | Excel Discussion (Misc queries) | |||
Unary operators | Excel Worksheet Functions |