Hi,
I am looking for a way to dynamically change which formula is used depending on the value in another cell, example:
<colgroup><col><col></colgroup><tbody>
</tbody>
I am looking for a solution that does not require endless if-statements. Rather looking for a solution where one specifies the formula to be used in a range which is the applied through an index-match-statement or similar. I have tried using the INDIRECT function but it does not seem to convert the text into different formulas.
Any help is well appreciated!
/Axel
I am looking for a way to dynamically change which formula is used depending on the value in another cell, example:
If value is between | Use formula |
0-40 | ROUND |
40-100 | ROUNDUP |
100-1000 | ROUND |
1000-10000 | ROUNDDOWN |
<colgroup><col><col></colgroup><tbody>
</tbody>
I am looking for a solution that does not require endless if-statements. Rather looking for a solution where one specifies the formula to be used in a range which is the applied through an index-match-statement or similar. I have tried using the INDIRECT function but it does not seem to convert the text into different formulas.
Any help is well appreciated!
/Axel