|
How do I insert a symbol as part of a formula
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 |
How do I insert a symbol as part of a formula
Why not use conditional formatting. If all is good, format it to be GREEN
and if all is BAD, make it red. It's under FORMAT - Conditional Format "Rhonda" wrote: 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 |
How do I insert a symbol as part of a formula
I don't really understand your example but why not just have "exceeded time
limit" or "didn't exceed time limit" appear depending upon the situation. -- Brevity is the soul of wit. "Rhonda" wrote: 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 |
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 |
How do I insert a symbol as part of a formula
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 |
How do I insert a symbol as part of a formula
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 |
How do I insert a symbol as part of a formula
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 |
How do I insert a symbol as part of a formula
|
How do I insert a symbol as part of a formula
|
How do I insert a symbol as part of a formula
You can also insert a smiley face (˜º˜»), by typing ALT+1 or 2 on the
numeric key pad) Rhonda wrote: 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 |
| All times are GMT +1. The time now is 07:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com