Set manufacturing cost depend of volume

[Emiliano_Palaqu]

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

[Steve · Accepted solution]

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])

[Emiliano_Palaqu]

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!