Hello, I'm having lots of trouble with writing Excel formulas that will automatically populate the gray boxes with the required response.

E F G H Write a formula that will Displays "Markdown" if the product is a Marker, or if the product is a Red Pen that costs more than $6. Displays "Regular" if not. Product Color Price Pen Rec 2.00 Marker Black 6.00 Pen Rec 7.00 Marker Black 4.00 Pen Rec 5.00 Marker Black 3.00 Indicate the sum of the prices of the product selected Marker Follow the rules in the following table and write "Discount" or "No Discount" RED and > 10 Discount GREEN and > 15 Discount Blue and > 20 Discount RED 12.00 Item Descr tion VR