Arrows And Formulas
 

Hi,

I'm wondering if its possible to create a formula or some other cell
function that compares the values in two cells and draws an arrow
accordingly... for example, if we are comparing current month sales to
previous, the value in cell A could be 10 (previous month) and the value in
cell B could be 5 (current month), i.e. the number has gone down from 10 to 5
so in cell C the arrow points down and vice versa, if the number has stayed
the same the arrow is horizontal.

Any help would be greatly appreciated.

Thanks

Arrows And Formulas
 

Format cell C with font Windings 3 and enter formula:
=IF(A1=B1,"g",IF(A1B1,"i","h"))

HTH
--
AP

"Langoose" a écrit dans le message de
news: ...
Hi,

I'm wondering if its possible to create a formula or some other cell
function that compares the values in two cells and draws an arrow
accordingly... for example, if we are comparing current month sales to
previous, the value in cell A could be 10 (previous month) and the value
in
cell B could be 5 (current month), i.e. the number has gone down from 10
to 5
so in cell C the arrow points down and vice versa, if the number has
stayed
the same the arrow is horizontal.

Any help would be greatly appreciated.

Thanks

Arrows And Formulas
 

I had a solution given to me for something very similar in the thread
below:

http://www.excelforum.com/showthread.php?t=493445

However life is much simpler if you could use a conditional format say
if the value goes up green, down red.

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=541464