Hi All,

1. I have cell A! filled with 5:1 and the cell ix "TEXT" formatted.
2. I want to extract 5 out of it (I did the same using the formula =LEFT(A1,FIND(":",A1,1)-1) ).
3. Now i want to check a condition whether 5 (extracted value) is < 6 (Here 6 is constant not in any cell).
4. I tried with =IF((LEFT(C12,FIND(":",C12,1)-1)<"5"),"YES","NO") but it is always printing NO as result even though if i change the value in cell A1 to 5 or 7.

Any help appreciated. Further i need to extract second part and check that value for some condition.

Regards,
Nagaraja S