Try something like this:

Prev score in B2
New score in C2
D2: =CHOOSE(SIGN(C2-B2)+2,"Decrease","Same","Increase")

Copy D2 down as far as you need


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Michael" wrote:

> Hi Folks - I have this data:
>
> StudentID Pre-test Score Post-test Score
> 1 100 110
> 2 90 85
> 3 95 95
>
> I'd like to create a formula that compares the two numbers, then determines
> whether the post-test score was an increase, decrease or stayed the same.
> Any ideas? Thanks.
>
> Michael
>
>
>
>