Hi,

I am looking to build a formula that incorporates a three tier compensation structure.

For example, sales between 0-$2M*.0025, sales between $2M-$4.5M*.004, and sales over $4.5M*.005

Any help is appreciated. Thank you!

AJ