Set manufacturing cost depend of volume

Greetings everybody, I need community help.
I need to set the price of manufacture of some product depending of its volume, but needs to be avoiding set this values in a formula, I need to fin the range in a table.

Example: If I print 238 pages, find the price corresponding to volumen between 101 and 200, then multiply the unite pribe by printed pages.

PRINTED PRICE TOTAL
238 250 59500

Ive made a list with a prices and ranges

ARTICLE FROM TO PRICE
PRINTING 1 100 $300,00
PRINTING 101 200 $250,00
PRINTING 201 300 $200,00

I really appreciate you help

App formula expression for the Price column of the first table (with the Printed column):

ANY(
  SELECT(
    Prices[Price],
    AND(
      ("PRINTING" = [Article]),
      ([_THISROW].[Printed] >= [From]),
      ([_THISROW].[Printed] <= [To])
    )
  )
)

App formula expression for the same table’s Total column:

([Printed] * [Price])
6 Likes

Works Great!, I will try to understand the logic of the formulas involve, but works great. Thank you for your mega fast response!

Have a great week!

3 Likes