Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts
    hi all,

    is there a way you can use a symbol like "arrow up" if the if logic/condition is poistive and "arrow down" if the if logic/ condition is negative.

    dubdub
    TIA
    dubdub

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The Symbol font that comes with Windows contains up and down arrows: the up arrow is character 173 and the down arrow character 175.
    To use the symbols in a formula, start by turning on NumLock.
    Start entering the formula:

    =IF(some condition,"

    where some condition is the condition you want to test, for example D1>100.

    Now hold down the Alt key and type 0173 on the numeric keypad.
    You should see some kind of hyphen but don't worry.
    Type

    ","

    Hold down the Alt key and type 0175 on the numeric keypad.
    Finish the formula by typing

    ")

    The formula should look like

    =IF(some condition,"-*","")

    Click the green check mark in the formula bar to confirm the formula.
    Set the font of the cell to Symbol.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks HansV, perfect. is there a number for the check mark.

    dubdub
    TIA
    dubdub

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Alt-0214 from num keypad, then switch to symbol font.

    Steve

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    In addition to Steve's reply: to find the code for other symbols, select Insert | Symbol and select Symbol from the Font dropdown list.
    Locate the symbol that you need, and look at the lower part of the Insert Symbol dialog.

  6. #6
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks to you both,HansV & Steve.

    dubdub
    TIA
    dubdub

Posting Permissions

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