Code Tag Test

[Joe4]

Here is a formula:

=IF(A1<10,"A","B")

 

[xenou]

Test:

=IF(A1<10,"A","B")

 

[xenou]

Test:

=IF(E8<C2*0.1,"True","False")

 

[Peter_SSs]

I'm expecting this to be OK because the < sign is followed by a number
=IF(C8<6,1,2)

I'm expecting this to fail because the < sign is followed by a letter
=IF(C8<H8,1,2)


and that's when you need the alternative (eg space after)
=IF(C8< H8,1,2)

 

[Marcelo Branco]

I expect this to be Ok
=IF(C8<=H8,1,2)