Forum Discussion
Excel - Return values based on multiple criteria in an input cell
Hello, I am looking for a bit of help in regards to returning numbers from a set of values in a column. It is complicated to use just an IF function as it involves multiple criteria.
For ex., I would like set up a formula/macro such that the output field to auto-populate based on the following criteria: 1) the smallest number in the input filed gets the biggest value, i.e. 9; the next smallest gets 7, and so on in decrements of 2; 2) if there are identical values in the input field, then they would have an averaged output. I'd appreciate any insights on what functions/approach would be appropriate for this. TIA
| Input | Output |
| 7 | 5 |
| 11 | 1 |
| 5 | 7 |
| 9 | 3 |
| 3 | 9 |
1 Reply
mahalinr Depending on your Excel version, perhaps one of the attached solutions gives you what your ask for.
