=IF(A2=B2,"SAME",IF(A2B2,"DOWN","UP"))
=IF((A2+B2)/2=D2,"SAME",IF((A2+B2)/2D2,"DOWN","UP"))


"george" wrote:

Hi All,

I need to compare data (%) on weekly basis and come with an anlysis improved
or not, Could you please guide me on this. For instance:

Week 1 Week 2 Status Week 3 status
99.00% 98.00% Down 99.00% up
98.00% 99.00% Up 97.00% down (but for the 3rd week the comparison
should also include Week 1 & 2 compared against 3)

--
Thanks,
George