Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare two Numbers - Determine Decrease, Increase, Same
Assuming your range is A1:C4 then in D2 =IF(C2B2,"Increase",IF(C2<B2,"Decrease","Same")) HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=506820 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare two Numbers - Determine Decrease, Increase, Same
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare two Numbers - Determine Decrease, Increase, Same
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Can you compare similar spreadsheets to determine a difference? | Excel Discussion (Misc queries) | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
macro to compare multiple cells to determine value | Excel Worksheet Functions | |||
How do I determine which numbers in a list equal a given sum? | Excel Discussion (Misc queries) |