Excel help needed - TranceAddict Forums

TranceAddict Forums (www.tranceaddict.com/forums)
- Chill Out Room
-- Excel help needed

Posted by jdat on Dec-01-2004 19:19:

Excel help needed

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

Posted by smokeape on Dec-02-2004 02:32:

Solution:

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

Us apes ain't so dumb after all.

[[[smoke]]]

White Room - Someday

Posted by jdat on Dec-02-2004 14:18:

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