LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith
 
Posts: n/a
Default How do I create dynamic arrows that track movements

Use the InsertSymbol... command. It will tell you the character number of the
symbol you want to use. Then put that in an If statement, as in:

=if(a1<b1,char(223),char (221))

Does this help?

--
Regards,
Fred


"Templeton" wrote in message
...
I want to be able to display up and down arrows pertaining to price movements
in a spreadsheet?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create conditional formatting to track due dates Soraiya Excel Worksheet Functions 2 October 14th 05 03:26 PM
How do I create a spreadsheet to track monthly inventory bholmes New Users to Excel 1 April 15th 05 06:45 PM
Can't create dynamic charts Brian Sells Charts and Charting in Excel 7 March 22nd 05 04:23 AM
how to create a dynamic descending list of months & years marika1981 Excel Discussion (Misc queries) 6 February 19th 05 03:57 AM
Can I create a dynamic email address in Excels hyperlink? ibrettferguson Excel Worksheet Functions 1 November 8th 04 02:24 AM


All times are GMT +1. The time now is 05:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"