I don't know if I quite understand your problem.

Format B1 to Wingdings2 and enter this formula into it:

=IF(A1=1,"P","")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

wrote in message
ups.com...
Hi,

I would like to show a tick in a cell if the value of the cell
alongside is equal to one.

I can put a tick in a cell using Insert-Symbol-change font to Wing-
Dings and select the tick.

However, if I now try to put a If statement around this tick (which
shows as a P in the cell) everything shows as Wing Ding characters.

Any idea how I can have an If statement that returns a tick when
statement is true.

Thanks,
Tom