You can insert a tick mark inside the formula, and ignore the cell format,

something like :

=IF(A10,"ˆš","")

Regards
Bosco


"JPS" wrote:

I need to know how to show a tick mark in a cell when my formula evaluating
data is correct. I have the formula working with an X and I can manually add
a tick mark to the cell but I need a formula to insert the tick.

Thanks for the Help!
--
JPS