use a symbol as the result of a IF formula
 

I want to use a check mark for the result of the iF formula if true.

use a symbol as the result of a IF formula
 

Use "?" in the true part of the condition.

"deb" wrote:

I want to use a check mark for the result of the iF formula if true.

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.

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.