- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- use symbols in a formula

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!

- use symbols in a formula posted by Paul Falla on Wed, 15 Oct 2003
- Re: use symbols in a formula posted by Andy B on Wed, 15 Oct 2003
- Re: use symbols in a formula posted by Paul on Wed, 15 Oct 2003