Forum Discussion
Why is the CHOOSE function not working?
If you use comma as decimal separator, use semicolon ; between the arguments of the functions.
If you use point as decimal separator, use comma , between the arguments of the functions.
Don't mix the two.
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.
You cannot use CHOOSE here - it expects a numeric argument.
See the attached version. It's not very interesting since the values in the three ranges are identical...
Thx Hans for the input!
However, when i download and open your file, i still get an (another) error message. In preview mode it says 'error 504'. When opening in Excel it says 'By moving or deleting cells, an invalid cell reference has occured. Or the function gives a reference error as result'.Do you have this on your side too?
I'm sorry, I don't know why you get that error message. I can open the workbook without problems (I tested it again just now).
