Instructions apply to Excel versions 2019, 2016, 2013, 2010, Excel Online, and Excel forMac.

Six Comparison Operators

There are six comparison operators available for you to use in Excel.

The most common usage is inside of theIFfunction.

Comparison Operators in Excel and Google Spreadsheets

All three values inside the IF function should be separated with commas.

The logical test can reference either values or cells in the Excel spreadsheet that contain values.

you could also nest formulas inside the comparison itself.

Excel VBA is used tocreate macrosfor automating actions inside of a spreadsheet.