change direction

[ian1010]

excel.jpg
hi
two questions
1 in column h could you tell me how i combine the (if )function from h and i so that i only have 1 column of functions
up in h5 is when c5 is greater than c4 and down is where d6 is less then d5
2in column j could you tell me a formula so that the direction(either up or down )remains the same until there is at least 2 values in the opposite direction, while the direction is down there has to be a min or two cells of up to cause a change of value to up
regards
ian

[vlady]

hello

try...

=if(c5>c4,"up",if(d6<d5,"down",""))

=if(and(c5>c4,d6<d6),"down","")