Compare two Numbers - Determine Decrease, Increase, Same

M

Michael

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
 
S

SteveG

Assuming your range is A1:C4 then in D2

=IF(C2>B2,"Increase",IF(C2<B2,"Decrease","Same"))


HTH

Stev
 
R

Ron Coderre

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
 
A

Ashish Mathur

HI,

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

=if(C1>B1,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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Autonumber field in Excel that behaves the same as Access 0
Value Increase/Decrease/No Change 1
Compare multiple rows for duplicated values in individual columns 1
Here's a challenge... 4
difference in numbers displayed as a +/- percentage 3
Excel 2002 Analysis ToolPak Regression Analysis Help Requested 1
Highest Score for each Test 4

Top