How to use IF and MID together

Originally Posted by primitivefuture

Hi,
I have some trouble to link the IF with the MID function.
I have a cell with the follwing value: 1+0+2 and I want to show in another cell if the first character is not 0, display OK, otherwise if it is 0 display NO
I have used the IF+MID functions, but it seems it doesnt work:
=IF(MID(H2;1;1)<>0;"OK";"NO")
It keeps showing NO, even if you put 0 as first char

Could you please help me?
Thanks

Try this out!

=IF(MID(H2,1,1)="0","OK","NO")

Regards
Swapnil.Next