Symbols in a formula

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Sep 21, 2003

• #2

You could format the cell with a Wingdings Font, and use eg:

=IF(C1<0.8,CHAR(74),"")

That's a J in Arial font. Your K would be CHAR(75).

 

Upvote 0

parry

MrExcel MVP

Joined

Aug 20, 2002

Messages

3,355

• Sep 21, 2003

• #3

Hi, in the cell that has the formula Format|Cells|Font tab and select Wingdings.

 

Upvote 0

Wil Moosa

Well-known Member

Joined

Aug 11, 2002

Messages

893

• Sep 21, 2003

• #4

Thanks to you both. What worked best =IF(C1<0.8,"K","") ánd formatting the cell to Windings.

The following page was of some use too: http://phoenix.phys.clemson.edu/tutorials/excel/symbols.html

p.s. Parry, how did you add the pic of the Lion to your message?

 

Upvote 0

Iridium

Well-known Member

Joined

Jul 15, 2002

Messages

2,831

• Sep 21, 2003

• #5

Wil Moosa said:

p.s. Parry, how did you add the pic of the Lion to your message?

Click to expand...

Go to your profile and have a look at the Avatar control panel

HTH

 

Upvote 0

parry

MrExcel MVP

Joined

Aug 20, 2002

Messages

3,355

• Sep 21, 2003

• #6

Iridiums covered it thanks. btw, I took that picture while in Namibia (Africa) this year. I thought I might be on the menu at the time . Cool country if you ever get the chance to visit

Good luck in your Excel..ling.

 

Upvote 0