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 ...
Consider the following:
Enter the following formula into B3 and copy down:
=FORECAST(A3, CHOOSE({1,2},$B$2,$B$10), CHOOSE({1,2},$A$2,$A$10))
Use ROUND(FORECAST(...), 0) if you want integer results.
Caveat: As usual, you might need to use semicolon instead of comma to separate parameters, and even different function names. It depends on your region and language configuration.