Create symbols based on text input

Hi,
Today is my first day on this site. It's fantastic.
I've been struggling with a problem and hope someone can help me.
I have a Task List and I want to generate a Tick mark into a symbol if the comment is "Done." But if the comment is "F/U" then I want another symbol (i.e. Exclamation or Star or ...).
I can generate the Check mark using a conditional statement but I fail when trying to generate a second symbol.
Any help will be very much appreciated.
Thanks.
**** Hirsch

Hi -

How about this: If(A1="Done",char(88),char(33))

char(88) returns an X while char(33) returns an ! (assuming your font is set to a standard alpha character set - If your font is Wingdings or Webdings or some other symbolic font you will get a different result)

Hope that helps.

Thank you for the great suggestion but there are three conditions that need to be considered, a) A1="Done"; b)A1="F/U"; c) A1 is blank.
Also, I'd like to use a Check mark instead of an X.
Can you suggest how I would accomplish this?
Regards,
****

Hi -

To make a check mark, you would need to change the font to Wingdings and revise the formula as follows:

=IF(ISBLANK(A1),"",IF(A1="Done",CHAR(252),CHAR(251)))

This puts a check mark if "Done", puts an X if "F/U", and puts a blank if the cell in A1 is blank (You didn't really say what you wanted done if it was blank).