could you please advise of the attached template.
1. i have multiple vendors ,where if i select one vendor with either product or warranty , corresponding discount number should highlight as mentioned
2. IF i add price , lets say USD , how can i automate to convert to aed
3. similarly for point 1 , i need to mentioned, if it is warranty, there is no customs charge to be added, rest it would be as per table
Could you please advise and assist as per template.