Could someone explain to me how to do the 7, 8, and 9 portion of the homework? I
ID: 397363 • Letter: C
Question
Could someone explain to me how to do the 7, 8, and 9 portion of the homework? I'm not understanding the whole if function and the if function incorporating vlookup into the formula.
3. In the Order Form worksheet, enter the following sample order data: Customer Dixie Kaufmann; Order Number 381; Order Date 4/5/2018; Street 414 Topeak Lane; City Fort Smith; State AK; ZIP 72914; Phone (479) 555-2081; and Delivery Type 3 Day. Explore 4. In cell B17, calculate the number of delivery days for the order. Insert an IF function that first tests whether the value in cell B16 is equal to an empty text string (). If it is, return an empty text string; otherwise, apply a lookup function to retrieve the lookup value from the table in the range F5:H8 using the value of cell B16 as the lookup value. 186 Excel Module 3 Performing Calculations with Formulas and Functions Explore 5. In cell B18, estimate the date of weekday delivery by inserting an IF function that tests whether cell B16 is equal to an empty text string. If it is, return an empty text string, otherwise apply the WORKDAY function using the values in cell B6 as the starting date and cell B17 as the number of days. 6. In cell D13, enter p4981 as the initial item ordered by the customer. In cell G13, enter 2 as the 7. In cell E13, enter an IF function that tests whether the value in cell D13 is equal to an empty 8. In cell F13, enter another IF function that tests whether the value in cell D13 is equal to an 9. In cell H13, enter another IF function to test whether the value in cell D13 is equal to an empty number of items ordered. text string. If true, return an empty text string. If false, apply the VLOOKUP function to return the name of the product ID entered into cell D13 empty text string. If true, return an empty text string. If false, return the price of the product ID entered in cell D13 text string. If true, return an empty text string; otherwise, calculate the value of the price of the item multiplied by the number of items ordered.Explanation / Answer
7.
=IF(D13=" "," ",VLOOKUP(D13,$j$2:$l$50,2))
Use the above function.
This means if D13 is equal to blank then value output will be Blank.
But if there is any Prod Id matching from the table, it will look and then the second column will be set, which is the name.