A developer needs to implement the following logic for each row in the Excel table:
- if the value in column “Price” is above 130$, then apply a discount of 10%
if the value in column “Price” is above 250$ then apply a discount of 7% and store the row in a separate table
- if the date in the column “Deadline” is less than 15 days from now, send a mail notification to the analyst mentioned column “Contact person”
- if the value in the column “Region” is “ELAMA”, apply an additional tax of 3,5%
- if the value in the column “Additional comments” is not empty, send the item for review to a responsible team
What is best suited to implement the above-mentioned logic?
Submit