| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert vlookup formula to link formula | Excel Worksheet Functions | |||
| How to convert a static formula to dynamic formula ? | Excel Worksheet Functions | |||
| Excell convert formula row to formula column | Excel Worksheet Functions | |||
| how to convert a formula into text in order to display the formula | Excel Discussion (Misc queries) | |||
| convert formula to its value | Excel Discussion (Misc queries) | |||
Linear Mode
