Banded Fee Structure Formula Assistance

[LDAllen2023]

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]

@LDAllen2023 

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.

[#3]

Hi Hans,

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