Expression based off three variables

[Rurrea]

Ok. Based off sold price of an item in order details…

we are doing an extended warranty that’s has a set price sheet.

conditions to be meet to determine cost of extended warranty

sold price must be greater than [Column b]
sold price must be smaller than [column c]
and user must manually select term (2 year or 4 year) to match Column a

the cost of extended warranty will be the value of column D being that the row match all three variables above