First drop down: (E5=E2, FALSE, TRUE, E2=B2, E1=E2, E2="Discount")

Second drop down: (B2, FALSE, B2*E4, TRUE, B1, A1)

Third drop down: (E2*E4, A1, B2*E4, A2, FALSE, B1, True)

Find the price for each item charged to the customer in cell E5 based on whether they receive a discount using an IF statement. How it is supposed to work: Price status can only be "Regular" or "Discount". When the Price status is "Regular" the Priced is equal to the Regular Price. When the Price status is "Discount" the Price is equal to the Discount Price. A B 1 Regular Price $ 25.95 2 Discount Price $ 23.45 3 4 5 6 7 Create the IF statement below. =IF( C D E F Customer ID: Price: 52697 Regular Quantity: Price Each: Total: 25 Can you create the IF statement in Excel without looking at the drop-down menu? 4