Cell formulas

  • Thread starter Thread starter Eric D.
  • Start date Start date
E

Eric D.

Hi,

I have a request that I can't seem to perform. I have two
columns. COL1 contains user inputed values. COL2 has a
formula.

Basically what I want to do is:
In COL2, I have the IF statement. If the statement = true,
then I want a "happy face" to show up in the cell. If not,
make the cell blank.

Is this possible?

TIA,
Eric
 
Hi
format column B with the font 'Wingdings'
now enter the following formula in B1
=IF(A1=1,CHAR(74),"")
 
Format the result cell as wingdings and use

=IF(A1=criteria,"J","")

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top