If you use functions like the IF function in Excel, you may wonder how to do an Excel less than or equal to, or alternatively a greater than or equal to calculation.
So to do a less than, you use the less than symbol (<) and for a greater than you use the greater than symbol (>).
To add the extra condition that it is less than OR equal to you simply put an equal sign behind it (<=). For greater than OR equal to you do the same thing (>=).
It is important that you put the equal sign after the size indicator otherwise Excel won’t recognise it and say ‘We found a typo in your formula and tried to correct it to …..’.