HI,

You may try the following trick to depict up and down arrows instead of text

=if(C1B1,Alt+24,Alt+25)

The Alt+24,Alt+25 is not typed. Instead hold down the Alt key (num lock key
is turned on) and type 24 on the numeric keypad

Regards,

Ashish


"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