Formula to display Odd/Even pattern

Hi,

Please try the following formula in K1

=IF(ISODD(C1),"O","E")&IF(ISODD(D1),"O","E")&IF(ISODD(E1),"O","E")&IF(ISODD(F1),"O","E")&IF(ISODD(G1),"O","E")&IF(ISODD(H1),"O","E")