Results 1 to 15 of 42
Thread: Symbol Possible In IF Formula?

20090831, 12:17 #1
 Join Date
 Mar 2001
 Location
 Norwich, Connecticut, USA
 Posts
 152
 Thanks
 15
 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

20090831, 13:21 #2
 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.

20090831, 18:00 #3
 Join Date
 Mar 2001
 Location
 Norwich, Connecticut, USA
 Posts
 152
 Thanks
 15
 Thanked 0 Times in 0 Posts
[quote name='VegasNath' post='791547' date='31Aug2009 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

20090831, 23:16 #4
 Join Date
 May 2008
 Location
 India
 Posts
 306
 Thanks
 0
 Thanked 0 Times in 0 Posts
[quote name='rjstorms' post='791614' date='01Sep2009 04:30']Thanks, Nathan. Works like a charm!
Robert[/quote]
or try this expansion. it is something fancy.
[attachment=85351:untitled.JPG]Regards
Prasad

20090901, 07:48 #5
 Join Date
 Sep 2007
 Posts
 1,203
 Thanks
 0
 Thanked 0 Times in 0 Posts
[quote name='prasad' post='791625' date='01Sep2009 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(A1B1)& " places". Now that would be fancy.

20090901, 10:56 #6
 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.
▲♠♣♥

20090901, 11:41 #7
 Join Date
 Sep 2007
 Posts
 1,203
 Thanks
 0
 Thanked 0 Times in 0 Posts
[quote name='mbarron' post='791673' date='01Sep2009 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)?

20090901, 11:52 #8
 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) ?

20090901, 12:43 #9
 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.

20090901, 13:15 #10
 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 ▼ ?

20090901, 14:03 #11
 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.

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

20090901, 15:07 #13
 Join Date
 Aug 2004
 Location
 Connecticut, USA
 Posts
 816
 Thanks
 0
 Thanked 0 Times in 0 Posts
[quote name='StuartR' post='791708' date='01Sep2009 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 ▲.

20090901, 16:42 #14
 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]

20090901, 16:50 #15
 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].