Welcome Guest
You last visited January 24, 2017, 12:09 pm
All times shown are
Eastern Time (GMT-5:00)

# Can anyone break this formula up?

Topic closed. 4 replies. Last post 11 years ago by lottaloot.

 Page 1 of 1
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: December 7, 2005, 3:27 pm - IP Logged

=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)>4,"H","L"))

and this

=CONCATENATE(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")))

but it doesn't work.

Could it be due to the parenthesis?

L ttaL   T

ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
5984 Posts
Online
 Posted: December 7, 2005, 3:56 pm - IP Logged

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

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: December 7, 2005, 4:05 pm - IP Logged

Thanks CARBOB

You're always there when I need you.

L ttaL   T

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: December 7, 2005, 4:08 pm - IP Logged

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

L ttaL   T

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: December 7, 2005, 4:47 pm - IP Logged

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

L ttaL   T

 Page 1 of 1