This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

Expression based off three variables

Posted on 02-24-2025 01:23 PM
Rurrea
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

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

IMG_8586.png

 

 

0 4 117
Topic Labels
0 Likes
Reply
4 REPLIES 4
Top Labels in this Space