Hi, hope someone can assist, i want to add some arrow syimbols in to a formula, so that when the formula works out it shows an up arrow for higher or a down arrow for lower, i am using this formula at the moment because i dont know any better but it works, putting in the word up or down:
I have entered the following formula in to a cell: =IF(S3<R3,"DOWN","UP") it works however i want to replace the word Down and up with the relevant arrows symbol. How do i do this?
Thanks
Last edited by zol590; 05-27-2010 at 06:35 AM.
Try using
=IF(S3<R3,6,5)
and use a font of Webdings. You could also use conditional formatting to use different colours for up and down.
Hi, .
if you format - for istance- the cell that contains your formula using wingdings 3, you could write something like
=IF(S3<R3,6,5)
to obtain down arrow (6) and up arrow (5)
I'm sure Excel 2007 can offer wonderful way of formatting cells.
----------------------------------------
Using your standard format you could write directly in the formula something like.
=IF(S3<R3,"▼","▲")
If press ALT+31 you obtain ▼, ALT+30 is ▲
Or ALT+25 is ↓ and ALT+24 ↑
Just to give you a first answer.
Regards
Thanks Bob, i will give this a try
Many thanks Canapone
I've tried this. It doesn't seem to work in excel 2007. Am I doing something wrong? Thanks.
If you cant't get an arrow when you press ALT and type 24, you are probably not using the numeric keypad.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks