Forum Discussion
Why is the CHOOSE function not working?
I have a spreadsheet with 3 entry fields: B23 | Dropdownlist with 3 options (products) C23 | Width D23 | Height In cell E23 I would like to automatically calculate the price based on a matrix ...
Tried to fix it, but no success. Maybe you can give it a try in the XLS file I shared?
Here's a sample file, something I created a while ago using three years worth of US Federal Income Tax tables. When one uses the tax tables to calculate taxes owed, there is first a choice of filing status--Single, Married, Married but Filing as Single, etc.--so just as your spreadsheet needs to choose which table to use, so does this. In fact, there are two choices to be made in order to determine what portion of the single combined table to use and drop downs are used for each:
- Choose the tax year
- Choose the Filing Status
I'm sorry it doesn't come with documentation on how it all works, but it does work and, if I do say so myself, it's pretty smooth. It also makes use of the LET function, which requires a relatively new version of Excel.