How to write an if statement in excel?
The IF function in Excel is one of the most popular conditional formula functions, and it allows you to make logical comparisons between a value and what you expect.
=if(Condition , Result when matched, result when not matched);nn;
If A2 is less than 10, (exclude 10), then the value for B2 is “<10”, else the value for B2 is “>=10”.
As now A2 is nothing, in Excel, it will be considered as 0. Therefore, the result for B2 is “<10”.