if (condA=true,"Ï") How to use function in cells to "print" webdings characters?
C crapit Jan 25, 2007 #1 if (condA=true,"Ï") How to use function in cells to "print" webdings characters?
P Pete_UK Jan 25, 2007 #2 You can't include the font information within a formula - you have to format the cell with the webdings font first, then your formula would be: =IF(condition,character,"") where "character" is the letter or string that you want to appear. Hope this helps. Pete
You can't include the font information within a formula - you have to format the cell with the webdings font first, then your formula would be: =IF(condition,character,"") where "character" is the letter or string that you want to appear. Hope this helps. Pete
C crapit Jan 25, 2007 #3 ITs in the starting message You can't include the font information within a formula - you have to format the cell with the webdings font first, then your formula would be: =IF(condition,character,"") where "character" is the letter or string that you want to appear. Hope this helps. Pete
ITs in the starting message You can't include the font information within a formula - you have to format the cell with the webdings font first, then your formula would be: =IF(condition,character,"") where "character" is the letter or string that you want to appear. Hope this helps. Pete
P Pete_UK Jan 25, 2007 #4 I don't understand what you mean. Is this a question? And, if so, can you give a few more details? Pete
I don't understand what you mean. Is this a question? And, if so, can you give a few more details? Pete
C crapit Jan 27, 2007 #5 OH i see, the formula key in as normal the character wise, paste it in the function, then format cell to be the desire fonts to achieve output I don't understand what you mean. Is this a question? And, if so, can you give a few more details? Pete
OH i see, the formula key in as normal the character wise, paste it in the function, then format cell to be the desire fonts to achieve output I don't understand what you mean. Is this a question? And, if so, can you give a few more details? Pete