I am building a savings calculator, and I'm using Airtable to store a Rate Table, and also to do the formula based calculations needed for the project.
Here's what I want to do: Have a formula that takes value x and checks if it is in a range of a and b in a specific row. Once it identifies what row, and therefore what range it is in, it needs to show/equal value y.
Here is what I have so far: (But it is giving me an error)
While switch statements are elegant, it can get overwhelming trying to cram all that logic inside there. Might be easier to use IF's & AND's for this example. See below. I went up to 40K, but you get the idea; just keep expanding it. If a value is < 10001 or >40000 (in my example), the function returns a default value ("Default / Out of range value").