How to use IF and MID together

**primitivefuture** · 09-09-2011, 05:19 AM

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

**arthurbr** · 09-09-2011, 05:25 AM

Try

=IF(LEFT(h2,1)<>"0";"OK";"NO")

**Next** · 09-09-2011, 05:30 AM

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