Create If statement that returns a tick when true
Appreciate the feed-back.
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
wrote in message
ps.com...
On Nov 7, 1:45 pm, "RagDyer" wrote:
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- Hide quoted text -
- Show quoted text -
Fantastic thanks !
|