|
Excel help needed
|
View this Thread in Original format
| jdat |
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 |
|
|
| smokeape |
Solution:
=IF(AVERAGE(E10:M10)>AVERAGE(E11:M11),"X","Y")
Us apes ain't so dumb after all.
:D
[[[smoke]]]
White Room - Someday |
|
|
| jdat |
| quote: | Originally posted by smokeape
Solution:
=IF(AVERAGE(E10:M10)>AVERAGE(E11:M11),"X","Y")
Us apes ain't so dumb after all.
:D
[[[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 |
|
|
|
|
