Hi,

I’m writing an item order table and have been successful in pulling prices from a matrix based on qty input using the Tiered system, but I find I now need to include the ability to override the price.

The Tier Formula is below and works - it populates the name of the tier based on the quantity input

IF(Quantity > 1, IF(Quantity < 5, “Tier 2”,

IF(Quantity >= 5, IF(Quantity < 10, “Tier 3”,

IF(Quantity >= 10, IF(Quantity < 15, “Tier 4”,

IF(Quantity >= 15, IF(Quantity < 25, “Tier 5”,

IF(Quantity >= 25, “Bulk”)))))))), “single”)

Once the tier is populated, I’m using a SWITCH formula to pull in the correct price based on the price tier

SWITCH((Tier),

“Single”,{Single Unit Cost},

“Tier 2”,{2-4 Units Cost},

“Tier 3”,{5-9 Units Cost},

“Tier 4”,{10-14 Units Cost},

“Tier 5”,{15-24 Units Cost},

“Bulk”, {Bulk 25+ Plus})

I find that I need to be able to override a price if their is a special one off price for a given line item. But since I’m using a formula, there doesn’t seem to be a way to override a price pulled from the matrix. I’ve hit a wall. Any suggestions for writing this missing piece would be most appreciated. Thanks in advance!