Excel's logical functions ... In the example above, typing =ISTEXT([@Value to test]) into cell F1 would then automatically apply it to the other cells in column F in the table.

For example, assign “A” for scores above 90, “B” for scores between 80 and 90, and so on. Logical Tests in Aggregation: Embed logical tests directly into functions like `SUM` or `AVERAGE ...