# Thread: Symbol Possible In IF Formula?

1. 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

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

using Wingdings 3.

This will provide up and down arrows.

3. [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. [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]

5. [quote name='prasad' post='791625' date='01-Sep-2009 05:16']or try this expansion. it is something fancy.

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

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. 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. [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. 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. 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.

10. Wahey, Thanks Mike.

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

11. 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. Or you can simply use (A1=▲) as your test.

13. [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. 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:

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]

15. 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 Last

#### Posting Permissions

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