Excel Formula to select data over other columns

[mrsushi]

Trying to select the data in the order over other columns

Price quotes in columns
K+L
M+N
O+P
Q+R
S+T

My formula in cell U

IF(LEN(K3),K3,IF(LEN(M3),M3,IF(LEN(O3),O3,IF(LEN(Q3),Q3,IF(LEN(S3),S3,"")))))

My formula in cell V

IF(LEN(L3),L3,IF(LEN(N3),N3,IF(LEN(P3),P3,IF(LEN(R3),R3,IF(LEN(T3),T3,"")))))

For some reason the formula isn't picking up prices in the order ie if prices in k+l, select it
So for row 4, there are prices along the row, but I want to avoid the #N/A N/A and select the next available prices.

Is there something wrong with the formula?

 

[jasonb75]

Your checking the cell with LEN(), anything other than a blank / empty cell will have a length greater than 0 and will return TRUE.
Try replacing LEN() with ISNUMBER()