use a symbol as the result of a IF formula

T

Tyro

If you want a checkmark in a cell, you can enter
=IF(condition,char(252),"") in the cell and then format the cell with the
wingdings font. To change the formula in the cell, edit the formula in the
formula bar. If you want a checkmark in a box, return char(254) instead of
char(252)

Tyro
 
Top