Inspecting the sheet visually looking for equal values, we can see that columns A and B have a match at rows 4, 7, 10, and 15. We will be using this sheet as our sample data to show how the comparison operators work. The following is a sample sheet with two columns containing cells with random numbers (between 10 and 19 inclusive), as well as some cells with text. There are six operators available in Excel, that allow a comparison between the values contained in two cells.Ĭomparisons result in a TRUE or FALSE being returned (referred to as a boolean type), although as we’ll see later, the output can also be programmed to produce something more meaningful.
Excel Comparison OperatorsĪpart from comparing two values to determine whether they are the same or not, comparisons can also be made to see whether one value is greater or less than another value, as well as whether a value is greater than or equal to, and less than or equal to another value. Have sales gone up, have they gone down, or have they remained the same?Īs with any good software, Excel provides a few ways to perform comparisons and we’ll be taking a close look at these.īefore we dive in though, it would be a good idea to first get a basic understanding of Excel’s comparison operators. The data may be weekly or monthly sales figures in a report and there is a need to compare the current period’s figures against those of the previous to produce some kind of indicator. Spreadsheets mainly comprise of tabulated data, so it is only natural that at some point a comparison between the data contained in two columns is going to be required.
0 kommentar(er)
