I have a spreadsheet with one row per day; and three times per day 3 values are entered;

Is there a way I can have a calc function that calcs the previous days averages and returns a symbol indicating an upwards or downwards movement;
If so how would you implement the symbol?
I think I should be able to figure out the calc but I dont know how to make the function work in other words:
if AVERAGE[E10:M10] > AVERAGE[E11:M11] then display symbol X
if AVERAGE[E10:M10] < AVERAGE[E11:M11] then display symbol Y


sheet looks like :
Value 1 Value 2 Value 3
date 1 2 4 2
date 2 DOWNWARDS 1 2 2
date 3 UPWARDS 5 8 3

Solution:

=IF(AVERAGE(E10:M10)>AVERAGE(E11:M11),"X","Y")

Us apes ain't so dumb after all.


[[[smoke]]]

White Room - Someday

quote:

Originally posted by smokeape Solution: =IF(AVERAGE(E10:M10)>AVERAGE(E11:M11),"X","Y") Us apes ain't so dumb after all. [[[smoke]]] White Room - Someday

Well aint' you a smart fellow but I may to display an actual symbol like an up or down arrow .... how do you do a link like that ?

I think I know the answer but I'm not sure