How to set webdings character in if function???

[crapit]

if (condA=true,"Ï")





How to use function in cells to "print" webdings characters?

 

[Pete_UK]

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

 

[crapit]

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

 

[Pete_UK]

I don't understand what you mean.

Is this a question? And, if so, can you give a few more details?

Pete

 

[crapit]

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

 

[Paul Morgan]

you could use an if condition in vba