Re: Condensing a Range of numbers.
So have been trying to figure out the formula for this.
Originally Posted by jasantacruz
Have got this far (Not sure it's even right, the maths need to be spot on or it won't work for me);
=IF(A1>100,99,IF(A1>80, ((99-86)/(100-80))*(A1-80)+86,IF(A1>60, ((85-75)/(81-61))*(A1-61)+76,IF(A1>45,((75-64)/
And then I seem to get lost. I keep looking over and over the formula's that you have given me already Empty Set but at this point (In my eyes anyway) any pattern dissapeard in regard to the next (....-....) ) i'm lost. I mean am I even on the right track.