Microsoft Office has a number of comparison operations so you can check if a value is greater than, equal to or less than another value using the standard greater than, less than and equal symbols.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...