PDA

View Full Version : Solved: Insert picture



Sathisc
06-17-2010, 02:33 AM
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
06-17-2010, 03:04 AM
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
06-17-2010, 04:58 AM
thanks mate