Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel - treat pairs of figures differently according to values
I want to use Excel to evaluate the results of a psychometric test.
The test produces pairs of figures. Each figure can be positive or negative If both are positive or both are negative I want the absolute difference If one is positive and the other negative I want to sum them If the first is positive and the second negative then I want to maket he figure produced above positive If the first is negative and the second positive I want to make the figure produced above negtive Any ideas? |
#2
|
|||
|
|||
try
=if(Abs(A1)+Abs(B1)=Abs(A1+B1),Abs(A1-B1),if(A1<B1,-1,1)*Abs(A1+B1)) where your first number is is A1 and the second in B1 "Alistair" wrote: I want to use Excel to evaluate the results of a psychometric test. The test produces pairs of figures. Each figure can be positive or negative If both are positive or both are negative I want the absolute difference If one is positive and the other negative I want to sum them If the first is positive and the second negative then I want to maket he figure produced above positive If the first is negative and the second positive I want to make the figure produced above negtive Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) |