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 F $ 25.95 $ 23.45 E Customer ID: 52697 Price: Regular 1 Regular Price 2 Discount Price 3 4 5 6 7 25 Quantity: Price Each: Total: Create the IF statement below. Can you create the IF statement in Excel without looking at the drop-down menu? Find the price for each item charged to the customer in cell E5 based on whether they receive a discou 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 F B 1. Regular Price $ 25.95 2 Discount Price $ 23.45 3 D E Customer ID: 52697 Price: Regular 4 25 5 Quantity: Price Each: Total: 6 7 Create the IF statement below: =IF0 . Can ement in Excel without looking at the drop-down menu? E5=E2 FALSE TRUE In the E2-B2 I formula would you enter in cell C3 that could be copied to cells D3 and E3, and wo for e E1-E2 E2-"Discount Find the price for each item charged to the customer in cell E5 based on whether they receive a discoun 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 C F A 1 Regular Price 2 Discount Price 3 B $ 25.95 $ 23.45 D Customer ID: Price: E 52697 Regular 4 25 5 Quantity: Price Each: Total: 6 7 Create the IF statement below: 4 =IFC . Can you create the IF stater without looking at the drop-down menu? B2 FALSE B2 E4 TRUE B1 B1 A1 in the picture below, what f for each week? Id you enter in cell c3 that could be copied to cells D3 and E3, and wou E Find the price for each item charged to the customer in cell Es based on whether they receive a discount u 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 B F 1 Regular Price 2 Discount Price 3 $ 25.95 $ 23.45 D E Customer ID: 52697 Price: Regular 4 25 5 6 7 Quantity: Price Each: Total: Create the IF statement below: =IFC . . ng at the drop-down menu? Can you create the IF statement in Excel E24 A1 B2E4 In the picture below, what formula would A2 for each week? FALSE B1 B TRUE cell 3 that could be copied to cells D3 and E3, and would D Waal Alaska