The IF function checks data against your condition and returns one result if it is true, and another if it is false.

It can be applied to text (e.g., "Moscow") and numbers (e.g., >1000), and can also be combined with AND/OR.

For formulas to work correctly, it is important to properly handle cells with errors. Learn more about calculating the average without zeros and errors in Excel in our guide.

🔗 Source: excel.rf