How do I insert a symbol as part of a formula
Change the font for cell B1 to Wing Dings. Then use the letter "J" for a
happy face and the letter "L" for a sad face.
=IF(A1-0.06250,"L","J")
Hope this helps.
Paul
"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
|