use symbols in a formula

Giganews Newsgroups
Subject: use symbols in a formula
Posted by:  kit (anonymo…@discussions.microsoft.com)
Date: Wed, 15 Oct 2003

Hi
Doing an autonmated worksheet for schoolkids.
I have a worksheet with division sums etc set out  that
they complete. If correct I want to insert a smiley if
wrong unsmiley next to their answer.
Did this with an If function  with the inserted value as a
wing ding for smiley etc.  However in the worksheet cell a
black dot is added whatevever wing ding character is added.
I assume this is to do  with the cell holding the formula
being formatted for wingdings?
If I use a word in arial the IF formula works OK.
Anyone know of a workaround, or a more elegant solution?
Thanks
Busy Teacher!

Replies