Thread: How do I create dynamic arrows that track movements
View Single Post
  #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?


Reply With QuoteReply With Quote