Spreadsheet: if cell contents is greater

I have a spreadsheet, where I want to check if the contents of each cell is greater than a certain value. If TRUE, I’d like to return “YES”, so I filter on these cells. I googled a bit and found the following instructions.

The logical test is as follows:

=IF(logical_test,if_true,if_false)

Therefore, if I want the contents to be greater than 80:

=IF(A1>80,"Yes","No")

Here’s an example. I want cells with values from column “corrC” larger than 0.3:



Leave a comment