Forum Discussion
Banded Fee Structure Formula Assistance
Hi, I am a little stuck on how to develop my cost formula for banded pricing. I will be charging based on the number of personnel serviced and basically have bands ranging from 0-1,000, 1,001-2,000 and so on. If someone could lend the proper formula and information, it would truly be helpful. Thanks in advance for your time!
One option is a lookup list:
The lookup list in the above example is in D2:E7.
The formula in B2 is
=VLOOKUP(A2,$D$2:$E$7,2)
This can be filled or copied downwards.
- Hi Hans,
Thank you very much for responding. I will try that….
