View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Deb Deb is offline
external usenet poster
 
Posts: 102
Default use a symbol as the result of a IF formula

Thank you so much, it worked perfect. Thanks again

"Tyro" wrote:

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.