| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I insert a symbol as part of a formula
|
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I insert a symbol as part of a formula
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Insert a Formula with a Macro | Excel Discussion (Misc queries) | |||
| Insert Formula and Copy to other cells | Excel Discussion (Misc queries) | |||
| Insert rows, keep a formula? | Excel Worksheet Functions | |||
| Challenging Charting | Charts and Charting in Excel | |||
Hybrid Mode
