Forum Discussion
Calculation
Hi. I have a series of numbers with resultant min and max value... I need to calculate the rest where 12 is 700 and 36 is 300...? Number Result 12 700 15 23 25 29 ...
=B$2-((B$2-B$10)/(A$2-A$10)*(A$2-A3))