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
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Symbol Possible In IF Formula?
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Symbol Possible In IF Formula?
- This topic has 41 replies, 8 voices, and was last updated 15 years, 9 months ago.
Viewing 21 reply threadsAuthorReplies-
WSVegasNath
AskWoody Lounger -
rjstorms
AskWoody Plus -
WSprasad
AskWoody Lounger -
WSVegasNath
AskWoody LoungerSeptember 1, 2009 at 7:48 am #1175840or try this expansion. it is something fancy.
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.
-
-
-
-
WSmbarron
AskWoody Lounger -
WSVegasNath
AskWoody Lounger
-
-
WSVegasNath
AskWoody Lounger -
WSmbarron
AskWoody LoungerSeptember 1, 2009 at 12:43 pm #1175870 -
WSVegasNath
AskWoody Lounger -
WSmbarron
AskWoody LoungerSeptember 1, 2009 at 2:03 pm #1175900Sure, 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.
-
WSVegasNath
AskWoody LoungerSeptember 1, 2009 at 5:06 pm #1175939OK.
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.
Yes, the symbol is driven by an IF() formula which involves a Vlookup to another sheet.
Am I correct in fearing that I have run out of options?
-
-
WSVegasNath
AskWoody LoungerSeptember 1, 2009 at 4:42 pm #1175934Thanks 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?
-
WSVegasNath
AskWoody Lounger -
WSmbarron
AskWoody LoungerSeptember 1, 2009 at 5:53 pm #1175945For this formula:
=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
This portion should be used for the Red conditional formatting
IF(VLOOKUP(R12,’Admin Players’!$C:$AS,20,0)0
where A1 is the current cell -
WSVegasNath
AskWoody LoungerSeptember 1, 2009 at 6:05 pm #1175947Hi Mike,
Thanks for your help here, it’s really appreciated.
The easy one:
=FIND(A1,”▲”)>0
where A1 is the current celldoes not produce any result for me at all.
The more difficult one does not work as CF cannot reference other worksheets, only the current worksheet.
Am I missing something?
-
WSmbarron
AskWoody Lounger -
WSVegasNath
AskWoody Lounger -
WSfranciz
AskWoody Lounger -
WSMarkU
AskWoody LoungerSeptember 3, 2009 at 4:15 am #1176122An alternative suggestion…
If the formatting depends only on whether the number is positive, zero or negative, you can do it directly in the cell format. This is simpler than using conditional formatting, but very much more limited in what it can do.
I’ve also used the Arial font from the character map to produce the formula “[Green]▲0;[Red]▼0;[Blue]►0”. This formats positive numbers in green with a ▲, negative numbers in red with a ▼, and zeros in blue with a ►. You could also add another section at the end (separated by a semicolon) for blanks.
(Looks like I was beaten to it by Rory!)
-
-
WSmbarron
AskWoody Lounger -
WSrory
AskWoody Lounger -
WSfranciz
AskWoody LoungerSeptember 3, 2009 at 11:40 am #1176169 -
WSVegasNath
AskWoody LoungerSeptember 3, 2009 at 6:36 pm #1176234Thanks, but where and how do I get the symbol into the formula?
I did it by going to Insert | Symbol, and selecting my required symbols out onto the worksheet. Once I had the symbols in the ws, I copied them into my formula’s.
I’m starting to wish that I had not taken this route now though, I’ve created several problems that I now have to find workarounds for.
That’s progress
grrrrrrr..
-
WSfranciz
AskWoody LoungerSeptember 4, 2009 at 12:30 pm #1176332I did it by going to Insert | Symbol, and selecting my required symbols out onto the worksheet. Once I had the symbols in the ws, I copied them into my formula’s.
I’m starting to wish that I had not taken this route now though, I’ve created several problems that I now have to find workarounds for.
That’s progress
grrrrrrr..
That’s what I am doing and find it really cumbersome
I am yet to try the barron’s method
-
-
-
-
WSrory
AskWoody Lounger -
WSVegasNath
AskWoody Lounger -
WSrory
AskWoody LoungerSeptember 3, 2009 at 6:12 am #1176133FYI, your VLOOKUP formula is also very inefficient since it refers to 43 entire columns of data when you are only interested in 2 of them:
VLOOKUP(R12,’Admin Players’!$C:$AS,20,0)
could be:
=index(‘Admin Players’!$W:$W,match(R12,’Admin Players’!$C:$C,0))
or preferably limit the actual ranges rather than referring to entire columns. -
WSVegasNath
AskWoody LoungerSeptember 3, 2009 at 6:38 pm #1176235FYI, your VLOOKUP formula is also very inefficient since it refers to 43 entire columns of data when you are only interested in 2 of them:
VLOOKUP(R12,’Admin Players’!$C:$AS,20,0)
could be:
=index(‘Admin Players’!$W:$W,match(R12,’Admin Players’!$C:$C,0))
or preferably limit the actual ranges rather than referring to entire columns.Thanks for your input Rory, i’ll take a look at that when I overcome my other outstanding issue’s.
-
-
WSmbarron
AskWoody Lounger -
WSprasad
AskWoody Lounger -
WSfranciz
AskWoody LoungerSeptember 5, 2009 at 4:21 am #1176397Pl have a look on attachment. I am struggling with formating cell to % in 2 decimal places along with up/down arrow. Any suggestion.
Seem like it can’t be formatted as percentage due to adding in the symbol as its have become text
How’s about this if you need to include percentage symbol in the result?
-
-
WSrory
AskWoody Lounger -
WSprasad
AskWoody LoungerSeptember 5, 2009 at 4:36 am #1176399It would be much easier to put the symbols into the number format too, as in the attached. The percent format won’t work as you have it because the data in the cell is not a number.
Thanks Rory. I was trying to approach the same way but no such custom list is found. Is there a way to create custome lists and then make them available in formating box?
-
WSprasad
AskWoody Lounger
-
-
WSVegasNath
AskWoody LoungerSeptember 5, 2009 at 8:12 am #1176414It would be much easier to put the symbols into the number format too, as in the attached. The percent format won’t work as you have it because the data in the cell is not a number.
I dug myself a few holes following this thread, making improvements to a wb and later realising I had created restrictions.
I now see however that I can use symbols and text in a cell, whilst keeping the cell numeric for calculations, AND without conditional formatting.
It’s been a bumpy ride, but I thank you very much!! I’ve learned lots here and it’s made my wb much slicker!
-
-
WSrory
AskWoody Lounger -
WSprasad
AskWoody Lounger
-
-
WSrory
AskWoody Lounger -
WSprasad
AskWoody Lounger
-
Viewing 21 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Extended Windows Built-in Disk Cleanup Utility
by
bbearren
2 hours, 28 minutes ago -
Win 11 24H2 June 2025 Update breaks WIFI
by
dportenlanger
6 hours, 8 minutes ago -
Update from WinPro 10 v. 1511 on T460p?
by
CatoRenasci
3 hours, 25 minutes ago -
System Restore and Updates Paused
by
veteran
8 hours, 38 minutes ago -
Windows 10/11 clock app
by
Kathy Stevens
2 hours, 40 minutes ago -
Turn off right-click draw
by
Charles Billow
11 hours, 52 minutes ago -
Introducing ChromeOS M137 to The Stable Channel
by
Alex5723
15 hours, 23 minutes ago -
Brian Wilson (The Beach Boys) R.I.P
by
Alex5723
4 hours, 26 minutes ago -
Master patch listing for June 10, 2025
by
Susan Bradley
17 hours ago -
Suggestions for New All in One Printer and a Photo Printer Windows 10
by
Win7and10
9 hours, 2 minutes ago -
Purchasing New Printer. Uninstall old Printer Software First?
by
Win7and10
23 hours, 2 minutes ago -
KB5060842 Issue (Minor)
by
AC641
1 day, 3 hours ago -
EchoLeak : Zero Click M365 Copilot leak sensitive information
by
Alex5723
1 day, 6 hours ago -
24H2 may not be offered June updates
by
Susan Bradley
4 hours, 44 minutes ago -
Acronis : Tracking Chaos RAT’s evolution (Windows, Linux)
by
Alex5723
1 day, 18 hours ago -
June 2025 updates are out
by
Susan Bradley
6 hours, 58 minutes ago -
Mozilla shutting Deep Fake Detector
by
Alex5723
2 days, 9 hours ago -
Windows-Maintenance-Tool (.bat)
by
Alex5723
1 day, 18 hours ago -
Windows 11 Insider Preview build 26200.5641 released to DEV
by
joep517
2 days, 12 hours ago -
Windows 11 Insider Preview build 26120.4250 (24H2) released to BETA
by
joep517
2 days, 12 hours ago -
Install Office 365 Outlook classic on new Win11 machine
by
WSrcull999
2 days, 11 hours ago -
win 10 to win 11 with cpu/mb replacement
by
aquatarkus
2 days, 3 hours ago -
re-install Windows Security
by
CWBillow
2 days, 15 hours ago -
WWDC 2025 Recap: All of Apple’s NEW Features in 10 Minutes!
by
Alex5723
2 days, 18 hours ago -
macOS Tahoe 26
by
Alex5723
2 days, 13 hours ago -
Migrating from win10 to win11, instructions coming?
by
astro46
3 hours, 50 minutes ago -
Device Eligibility for Apple 2026 Operating Systems due this Fall
by
PKCano
2 days, 3 hours ago -
Recommended watching : Mountainhead movie
by
Alex5723
2 days, 4 hours ago -
End of support for Windows 10
by
Old enough to know better
3 hours, 15 minutes ago -
What goes on inside an LLM
by
Michael Covington
4 hours, 11 minutes ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.