Banded Fee Structure Formula Assistance

Copper Contributor

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!

2 Replies


One option is a lookup list:


The lookup list in the above example is in D2:E7.

The formula in B2 is




This can be filled or copied downwards.

Hi Hans,

Thank you very much for responding. I will try that….