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