ExcelBanter - View Single Post - How do I insert a symbol as part of a formula

Rhonda

Bernie,

That would be great! My email is . The formula you sent
did work but I would like to make the smiley or sad face colored, can I do
that? to emphasize (good versus bad)? I really appreciate your help on this.

"Bernie Deitrick" wrote:

To have a current ticking time, you need to use macros. Post your email address or reply to me
privately, and I will send you an example workbook with a timer that you could use.

HTH,
Bernie
MS Excel MVP

"romelsb" wrote in message
...
excuse me guys....how to do it in the formula if A1 must be the current
ticking time....thanks
--
"Bright minds are blessed to those who share them.."-rsb.

"Bernie Deitrick" wrote:

Rhonda,

Download a font that includes smiley faces as individual characters, then write the formula to
return the correct character number, and format the cell for that font. Use a formula like

=IF(A1VALUE("1:30:00"),CHAR(65),CHAR(66))

HTH,
Bernie
MS Excel MVP

"Rhonda" wrote in message
...
Hey Guys,

Is it possible for me to insert a "smiley face" or "sad face" symbol in
blank cell next a cell that has a formula in it? For instance, if the time
in cell A1 is 2:00 (minutes) but the limit is 1:30, how can I put a "sad
face" symbol in the blank cell B1 automatically, see below for an example:

Cell A1 has a time of 2:20 PM (the maximum time should be 1:30 - this limit
is not in the spreadsheet). I want to have cell B1 automatically populate a
"sad face" because the maximum was over 50 minutes OR

Cell A1 has a time of 1:20 pm (the maximum time should be 1:30 - this limit
is not in the spreadsheet). I want to have cell B1 automatically populate a
"smiley face" because the limit was under the required 1:30.

Does this make sense? This is a spreadsheet that calculates the time
someone arrives to a clinic and time they leave, the maximum should be 1 hour
30 minutes for the person to go through the procedure but sometimes it does
not happen within that time, I want the spreadsheet to show when it does and
doesn't with the "smiley face" symbol.

I hope this was explained correctly, any help would be greatly appreciate!

Rhonda