patricia80
New Member
Hello,
I have been working on Excel 2013, Working with advanced functions, page EX525, Case 4, problem number 7 and 8. I am stumped. Error codes keep popping up.
Many thanks,
Patricia
Question 7
In column K, create a nested IF function to determine the shipping cost for each instrument. Use the shipping code (column F) and the shipping charge options Pickup (0), Ground ($25), and Rush ($50) to assign shipping costs to each rental instrument.
Question 8
In column L, calculate the total cost, which is the sum of the rental charges, the insurance cost, and the shipping cost.
I have been working on Excel 2013, Working with advanced functions, page EX525, Case 4, problem number 7 and 8. I am stumped. Error codes keep popping up.
Many thanks,
Patricia
Question 7
In column K, create a nested IF function to determine the shipping cost for each instrument. Use the shipping code (column F) and the shipping charge options Pickup (0), Ground ($25), and Rush ($50) to assign shipping costs to each rental instrument.
Question 8
In column L, calculate the total cost, which is the sum of the rental charges, the insurance cost, and the shipping cost.