Convert -1 and 1 formula
 

Hi

Does anyone know a fromula where if you passed in -1 and 1 you would get -2
and -1 respectively?
For eaxample:
-1 ??? = -2
1 ???= -1

I also need a similar formular where you can get 1 and 2 from -1 and 1.
-1 ??? = 1
1 ??? = 2

Kind regards, Carl Gilbert

Convert -1 and 1 formula
 

Carl,
You want to return 2 values from 1 formula ?

NickHK

"Carl Gilbert" wrote in message
...
Hi

Does anyone know a fromula where if you passed in -1 and 1 you would
get -2
and -1 respectively?
For eaxample:
-1 ??? = -2
1 ???= -1

I also need a similar formular where you can get 1 and 2 from -1 and 1.
-1 ??? = 1
1 ??? = 2

Kind regards, Carl Gilbert

Convert -1 and 1 formula
 

Thanks for the reply, but I have it sussed now.

.5x -1.5 where x is your number for the first one.

.5x + 1.5 for the second one.


"NickHK" wrote in message
...
Carl,
You want to return 2 values from 1 formula ?

NickHK

"Carl Gilbert" wrote in message
...
Hi

Does anyone know a fromula where if you passed in -1 and 1 you would
get -2
and -1 respectively?
For eaxample:
-1 ??? = -2
1 ???= -1

I also need a similar formular where you can get 1 and 2 from -1 and 1.
-1 ??? = 1
1 ??? = 2

Kind regards, Carl Gilbert