Revision history [back]
 | 1 | initial version |
One method for labeling a row if there's a minimum value that must be met by at least one column is to use the IF function in a new column. The formula would look something like this:
=IF(MIN(A2:D2)>=X, "Met", "Not Met")
In this formula, A2:D2 represents the range of columns that need to meet the minimum value, and X is the minimum value that must be met. If the minimum value is met in at least one of the columns, the formula will return "Met" in the new column. If the minimum value is not met in any of the columns, the formula will return "Not Met".