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 | |
| 32 | |
| 34 | |
| 36 | |
| 36 | 300 |
2 Replies
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.
=B$2-((B$2-B$10)/(A$2-A$10)*(A$2-A3))
