| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
use a symbol as the result of a IF formula
I want to use a check mark for the result of the iF formula if true.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
use a symbol as the result of a IF formula
Use "?" in the true part of the condition.
"deb" wrote: I want to use a check mark for the result of the iF formula if true. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
use a symbol as the result of a IF formula
If you want a checkmark in a cell, you can enter
=IF(condition,char(252),"") in the cell and then format the cell with the wingdings font. To change the formula in the cell, edit the formula in the formula bar. If you want a checkmark in a box, return char(254) instead of char(252) Tyro "deb" wrote in message ... I want to use a check mark for the result of the iF formula if true. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
use a symbol as the result of a IF formula
Thank you so much, it worked perfect. Thanks again
"Tyro" wrote: If you want a checkmark in a cell, you can enter =IF(condition,char(252),"") in the cell and then format the cell with the wingdings font. To change the formula in the cell, edit the formula in the formula bar. If you want a checkmark in a box, return char(254) instead of char(252) Tyro "deb" wrote in message ... I want to use a check mark for the result of the iF formula if true. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| What does the $ symbol mean in a formula? | New Users to Excel | |||
| Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
| I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) | |||
| how do I assign a symbol to the result of a part of a nested IF s. | Excel Worksheet Functions | |||
Linear Mode
