Can anyone break this formula up?

Reply #4

lottaloot — Wed, 07 Dec 2005 21:47:16 GMT

It works. I was only copying half of the formula.

Reply #3

lottaloot — Wed, 07 Dec 2005 21:08:03 GMT

Works like a charm much shorter also. Correction The H/L formulaworks like a charm.It seems that I am having a problem with the E/O formula. Will keep trying. Maybe I left out something

Reply #2

lottaloot — Wed, 07 Dec 2005 21:05:48 GMT

Thanks CARBOBYou're always there when I need you.

Reply #1

CARBOB — Wed, 07 Dec 2005 20:56:05 GMT

lOTTALOOT,Try these.Carbob =CONCATENATE(IF(LEFT(B28,1)*1>4, H , L ),IF(MID(B28,2,1)*1>4, H , L ),IF(RIGHT(B28,1)*1>4, H , L ))=CONCATENATE(IF(ISEVEN(LEFT(B29,1)*1), E , O ),IF(ISEVEN(MID(B29,2,1)*1), E , O ),IF(ISEVEN(RIGHT(B29,1)*1), E , O

Can anyone break this formula up?

lottaloot — Wed, 07 Dec 2005 20:27:29 GMT

=CONCATENATE((IF(((LEFT(C2,1))*1)>4, H , L )),(IF(((MID(C2,2,1))*1)>4, H , L )),(IF(((RIGHT(C2,1))*1)>4, H , L )),(IF((ISEVEN(((LEFT(C2,1))*1))), E , O )),(IF((ISEVEN(((MID(C2,2,1))*1))), E , O )),(IF((ISEVEN(((RIGHT(C2,1))*1))), E , O ))) Don't know where SirMetro has gone, but I would like this formula to track H/L E/O separately and not together as it does now. Tried to break it up like this=CONCATENATE((IF(((LEFT(C2,1))*1)>4, H , L )),(IF(((MID(C2,2,1))*1)>4, H , L )),(IF(((RIGHT(C2,1))*1... [ More ]