Hi, you will need to subrtact the min number you have then divide by 2* (max-min):
in your example: 2*(7-3) = 8 (the divide factor) For each number: (3-3)/8 = 0 (lower limit) (4-3)/8 = 0.125 ... (7-3)/8 = 0.5 (upper limit) On Dec 16, 10:48 pm, JaH <[email protected]> wrote: > I have to scale somehow array of number to the level of 0-1/2. > > Is it possible to make a function (without Vb) which will find > corresponding values that i have, lets say array of numbers from 3.xxx > to 7.xxx in irregular steps, on the scale from 0 to 1/2 ? > > I have tried finding the biggest number and finding the multiplier > which makes it 0.5 but then if i use this m for multiplying all other > numbers i will not get 0 ... because my smallest number is 3.xxx > > I am not too good with arithmetic and with mathematical vocabulary as > you can see, so don't take this array, set and other things for > granted. > > Thanks a lot > > J
