Thread: use a symbol as the result of a IF formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
  
Posts: 1,091
Default use a symbol as the result of a IF formula
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

"deb" wrote in message
...
I want to use a check mark for the result of the iF formula if true.


Reply With QuoteReply With Quote