+ Reply to Thread
Results 1 to 7 of 7

Insert a symbol in to a formula

  1. #1
    Registered User
    Join Date
    05-27-2010
    Location
    Gillingham, Kent
    MS-Off Ver
    Excel 2007
    Posts
    3

    Insert a symbol in to a formula

    Hi, hope someone can assist, i want to add some arrow syimbols in to a formula, so that when the formula works out it shows an up arrow for higher or a down arrow for lower, i am using this formula at the moment because i dont know any better but it works, putting in the word up or down:

    I have entered the following formula in to a cell: =IF(S3<R3,"DOWN","UP") it works however i want to replace the word Down and up with the relevant arrows symbol. How do i do this?

    Thanks
    Last edited by zol590; 05-27-2010 at 06:35 AM.

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 365
    Posts
    2,946

    Re: Formula

    Try using

    =IF(S3<R3,6,5)

    and use a font of Webdings. You could also use conditional formatting to use different colours for up and down.

  3. #3
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2010
    Posts
    1,735

    Re: Formula

    Hi, .

    if you format - for istance- the cell that contains your formula using wingdings 3, you could write something like

    =IF(S3<R3,6,5)

    to obtain down arrow (6) and up arrow (5)

    I'm sure Excel 2007 can offer wonderful way of formatting cells.

    ----------------------------------------

    Using your standard format you could write directly in the formula something like.


    =IF(S3<R3,"▼","▲")


    If press ALT+31 you obtain ▼, ALT+30 is ▲

    Or ALT+25 is ↓ and ALT+24 ↑

    Just to give you a first answer.

    Regards

  4. #4
    Registered User
    Join Date
    05-27-2010
    Location
    Gillingham, Kent
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Formula

    Thanks Bob, i will give this a try

  5. #5
    Registered User
    Join Date
    05-27-2010
    Location
    Gillingham, Kent
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Formula

    Many thanks Canapone

  6. #6
    Registered User
    Join Date
    04-26-2011
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: Formula

    I've tried this. It doesn't seem to work in excel 2007. Am I doing something wrong? Thanks.

  7. #7
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: Insert a symbol in to a formula

    If you cant't get an arrow when you press ALT and type 24, you are probably not using the numeric keypad.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1