Solved: Insert picture

[Sathisc]

Hi,

If a cell is "0" I need that to get represented with symbol
☺

if not equal to "0" want to represent with symbol
N

I tried with if statement but doesnt work.


Thanks in advance.

Sathish

[macropod]

Hi Sathish,

Use:
=IF(A1=0,"J","N")
and format the cell with the Wingdings font. If you need the red colour, apply a conditional format for when the cell value equals N.

[Sathisc]

thanks mate