Spreadsheet: if cell contents is greater
Posted: 2023-08-31 Filed under: office | Tags: excel, if, spreadsheet Leave a commentI 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:

