Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, thanks for your reply, you have the right idea.
I have some funny formula's, been can not do things before, but later found the answer. was trying to Just "TEST" for which operator to use, for: < or instead of typing out 2 "half's" of the same formula bet there is a way to do that with some form of brackets, quotes.. something =IF($AK$2="u","<","" or [],[<] {<},{} like I say, answer to that would cut formula's in half. in your example, that is about what I had before. mine is double long for use of U or D answers (up or down). I can cut that in half, (but still..) e.g.: =IF(OR(S9=".",CP9={"",0},CQ9={"","n/a"}),"", IF(AND($AK$2="u",CP9IF(CP9<CQ9,CQ9,CR9)),"U",IF( AND($AK$2="d",CP9<IF(CP9<CQ9,CQ9,CR9)),"D","-"))) here's a trick I just rediscovered, used this before, should work: =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")))) = precludes a False condition, but gives a false "U", if number is same for both days.. no problem. Thanks. XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ----------- other formula was told I couldn't do: (new version works better) Hyperlink to put "in-document" Title lines (takes to exact spot of header, up or down, add or delete lines). This was a severe problem for doing work, lines moving. =HYPERLINK(IF(ROW($A$614)<(ROW($A614)-($W$1/2)),"#"&CELL("address",OFFSET($A$614,-1,1)),"#"&CELL("address",OFFSET($A$614,$W$1,1)))," A") - row($a614 no dollar sign, is row this formula is in - $w$1 is work around formula for amount of rows your screen shows (/below freezepane), formula is: (48 any number, minus last row in freeze pane=number rows you have showing). =48-CELL("row",$A$19) "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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert number into words | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions |