How to set webdings character in if function???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

crapit - 25 Jan 2007 12:41 GMT

if (condA=true,"Ï")

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

Reply to this Message

Pete_UK - 25 Jan 2007 13:18 GMT

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

> if (condA=true,"Ï")
>
> How to use function in cells to "print" webdings characters?

Reply to this Message

crapit - 25 Jan 2007 17:04 GMT

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

On Jan 25, 12:41 pm, "crapit" <biggerc...@yahoo.com> wrote:

> if (condA=true,"Ï")
>
> How to use function in cells to "print" webdings characters?

Reply to this Message

Pete_UK - 25 Jan 2007 17:17 GMT

I don't understand what you mean.

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

Pete

> ITs in the starting message
>
[quoted text clipped - 15 lines]
>
> > How to use function in cells to "print" webdings characters?- Hide quoted text -- Show quoted text -

Reply to this Message

crapit - 27 Jan 2007 11:51 GMT

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

On Jan 25, 5:04 pm, "crapit" <biggerc...@yahoo.com> wrote:

> ITs in the starting message
>
[quoted text clipped - 16 lines]
> > How to use function in cells to "print" webdings characters?- Hide
> > quoted text -- Show quoted text -

Reply to this Message