Voters 7
-
D
-
J
-
R
-
B
-
R
-
-
T
- + 1 voters
Lookup tables in calculators
- Open
- Subscribe
 |
involve.me |
It would be great if formulas also allowed lookup tables (useful for tiered pricing scenarios - e.g., if 1-5 units cost $100 each, 6-20 cost $90 each, and 21-50 cost $85 each, I should be able to enter a numerical answer and have the lookup table automatically map the correct price - right now the only way to do that is to enter each individual number in a drop-down with the right price entered as the answer for that number, but that's not really an option when you could have thousands of units. We could also do tiers in the drop-down, but then we won't be able to calculate a final price without asking a separate question for the exact number).
Activity Newest / Oldest
תומר אוחנה
Highly recommend adding the option to add a VLOOKUP formula
involve.me
Merged with: VLOOKUP formula