how in excel can i tell that
1
2
3
is growth
3
2
1
is loss
and
3
0
3
is no change
I want to just display the trend with a up , down or no change arrow
all the functions like trend etc and stdev show loss and gain as no
difference
how in excel can i tell that
1
2
3
is growth
3
2
1
is loss
and
3
0
3
is no change
I want to just display the trend with a up , down or no change arrow
all the functions like trend etc and stdev show loss and gain as no
difference
Consider:
=IF(endpoint-startpoint>0) then gain
=IF(endpoint-startpoint<0) then lose
=IF(endpoint-startpoint=0) then no change
--
Gary's Student
"usenet" wrote:
> how in excel can i tell that
>
> 1
> 2
> 3
> is growth
> 3
> 2
> 1
> is loss
> and
> 3
> 0
> 3
> is no change
>
> I want to just display the trend with a up , down or no change arrow
> all the functions like trend etc and stdev show loss and gain as no
> difference
>
>
>
>
Thanks Gary how ever that wont work in this kind of instance where the trend
is higher
10
20
10
30
9
40
9
and also this one where the trend is clearly lower
50
40
50
30
51
20
51
lastly this one where the trend is even
20
19
21
Any other ideas
Thanks
"Gary''s Student" <[email protected]> wrote in message
news:[email protected]...
> Consider:
>
> =IF(endpoint-startpoint>0) then gain
> =IF(endpoint-startpoint<0) then lose
> =IF(endpoint-startpoint=0) then no change
> --
> Gary's Student
>
>
> "usenet" wrote:
>
>> how in excel can i tell that
>>
>> 1
>> 2
>> 3
>> is growth
>> 3
>> 2
>> 1
>> is loss
>> and
>> 3
>> 0
>> 3
>> is no change
>>
>> I want to just display the trend with a up , down or no change arrow
>> all the functions like trend etc and stdev show loss and gain as no
>> difference
>>
>>
>>
>>
Are these meant to be equally-spaced values (eg at some time interval)
? In other words, does the row number imply an x-value to these
y-values? If so, then you could do a least-squares fit to the data and
derive the best "slope" of the values to indicate whether it is
increasing, decreasing or level.
It's been a few years since I last did this, so I can't help you with
the formulae straightaway, but I hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks