Page 1 of 3 123 LastLast
Results 1 to 15 of 42
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Norwich, Connecticut, USA
    Posts
    150
    Thanks
    14
    Thanked 0 Times in 0 Posts
    I want to create an IF formula that will place a symbol (either up arrow or down arrow) in a cell depending on the value in a referenced cell compared to the previous day's value. Is this possible? How? What cell format? Robert

  2. #2
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How about:

    =IF(G6>0,"p","q")

    using Wingdings 3.

    This will provide up and down arrows.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Norwich, Connecticut, USA
    Posts
    150
    Thanks
    14
    Thanked 0 Times in 0 Posts
    [quote name='VegasNath' post='791547' date='31-Aug-2009 14:21']How about:

    =IF(G6>0,"p","q")

    using Wingdings 3.

    This will provide up and down arrows.[/quote]

    Thanks, Nathan. Works like a charm!
    Robert

  4. #4
    3 Star Lounger
    Join Date
    May 2008
    Location
    India
    Posts
    306
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='rjstorms' post='791614' date='01-Sep-2009 04:30']Thanks, Nathan. Works like a charm!
    Robert[/quote]
    or try this expansion. it is something fancy.

    [attachment=85351:untitled.JPG]
    Attached Images Attached Images
    Regards
    Prasad

  5. #5
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='prasad' post='791625' date='01-Sep-2009 05:16']or try this expansion. it is something fancy.

    [attachment=85351:untitled.JPG][/quote]

    Hi Prasad,

    Please would you mind telling me how you get the symbols into the formula. I'm interested to know if a symbol could be used in the same cell as text and numbers.

    I would like to have a cell populated with a symbol followed by " "&sum(A1-B1)& " places". Now that would be fancy.

  6. #6
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You can copy the symbols out of the "character map" and use them within the formula. I got these straight out of the Arial Narrow font.
    ▲♠♣♥

  7. #7
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='mbarron' post='791673' date='01-Sep-2009 16:56']You can copy the symbols out of the "character map" and use them within the formula. I got these straight out of the Arial Narrow font.
    ▲♠♣♥[/quote]

    Thanks Mike, but how do I get to the character map (in vista)?

  8. #8
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi, found the character map, eventually...

    Am I correct in my finding that it is NOT possible to show a character in the same cell as text and a value (concatenated) ?

  9. #9
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    As long as the symbols are part of the font set you are using, you can use the symbols as part of the formula. You cannot have two different font types as part of a formula result. The attached picture shows the symbols being used in a formula. The font is Ariel.
    Attached Images Attached Images

  10. #10
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Wahey, Thanks Mike.

    Finally, is it possible to conditionally format a cell based on whether the value contains ▲, ►, or ▼ ?

  11. #11
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sure, you could use: =FIND(A1,"▲")>0 as your criteria for the conditional formatting. Or,if an IF() formula is driving the ▲, you could use the "TRUE" part of the formula. For example, if your formula is IF(A1>6,▲,"") you can use =A1>6 as the criteria for your conditional formatting formula.

  12. #12
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    Or you can simply use (A1=▲) as your test.

  13. #13
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='StuartR' post='791708' date='01-Sep-2009 15:12']Or you can simply use (A1=▲) as your test.[/quote]

    This is true if the ▲ is the entire result of the formula. Since VagasNath was inquiring about the concatenation of the symbol with more text, the A1=▲ would fail since the cell contains more than the ▲.

  14. #14
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks both, I'm still struggling slightly.

    Ignore the 237 & 72, the +6 and +1 are as I would expect.

    The formula in P16 resulting in -145 is:

    =IF(VLOOKUP(R12,'Admin Players'!$C:$AS,20,0)>0,"▲"&VLOOKUP(R12,'Admin Players'!$C:$AS,20,0),IF(VLOOKUP(R12,'Admin Players'!$C:$AS,20,0)<0,"▼"&-VLOOKUP(R12,'Admin Players'!$C:$AS,20,0),VLOOKUP(R12,'Admin Players'!$C:$AS,20,0)))

    This should be red, so should the -39 and -7. The red zero should not be red as it is neither <>0.

    Any idea's what I am doing wrong?

    [attachment=85354:lounge.GIF]
    Attached Images Attached Images

  15. #15
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I *think* I see my error. I was'nt sure what the relevance of the 6 was, and assumed that it had something to do with the symbol. I think I understand [stupidme].

Page 1 of 3 123 LastLast

Posting Permissions

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