Hi
Hope you can help.
I need to get the % change between 2 numbers.
Here are all the variations possible
1 2 1/2-1
2 1 2/1-1
1 -2 1/2-1*-1
-2 1 -2/1-1
-1 -2 -2/-1-1
-2 -1 -1/-2-1
Now these are the variations and lets assume the first number is in cell A1 and the second number is in cell A10, How could I have a formulae that would capture the correct return?
Any help would be greatly appreciates.
MM
Hope you can help.
I need to get the % change between 2 numbers.
Here are all the variations possible
1 2 1/2-1
2 1 2/1-1
1 -2 1/2-1*-1
-2 1 -2/1-1
-1 -2 -2/-1-1
-2 -1 -1/-2-1
Now these are the variations and lets assume the first number is in cell A1 and the second number is in cell A10, How could I have a formulae that would capture the correct return?
Any help would be greatly appreciates.
MM