Create If statement that returns a tick when true

[tomfabtastic]

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

 

[RagDyer]

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

Format B1 to Wingdings2 and enter this formula into it:

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

 

[tomfabtastic]

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 !
---------------------------------------------------------------------------











- Show quoted text -

Fantastic thanks !

 

[RagDyeR]

Appreciate the feed-back.
--

Regards,

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

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 !
---------------------------------------------------------------------------











- Show quoted text -

Fantastic thanks !