View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael
 
Posts: n/a
Default Compare two Numbers - Determine Decrease, Increase, Same

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