Answered

Find the best solutions to your questions at Westonci.ca, the premier Q&A platform with a community of knowledgeable experts. Join our Q&A platform and get accurate answers to all your questions from professionals across multiple disciplines. Get precise and detailed answers to your questions from a knowledgeable community of experts on our Q&A platform.

2. determine the handling surcharge for items which are fragile and insurance cost for items which have a high value. (handling surcharge for fragile items + insurance for high value items) write an excel formula in cell packlist!g3 to calculate this value for the corresponding item. handling surcharge and insurance values are given on sheet handling. round these charges to the nearest cent. copy your formula down the column to determine this value for each corresponding item.

Sagot :

ajeigbeibraheem

The handling surcharge for items that are fragile and insurance cost for items that have a high value are two different terms that can be filled in different cells on the Excel Sheet. On the Excel sheet, the excel formula that can be used to calculate the value of the corresponding item is:

  • = SUMIF (handling surcharge for fragile items: insurance cost for high_value items, criteria, [sum_range])

An Excel sheet is a spreadsheet that is used for calculating arithmetic operations, statistical calculations, and graphical analysis. In an Excel sheet, simple commands are input by using the Excel Formulas.

For the given example; the excel formula to be used is:

  • = SUMIF (handling surcharge for fragile items: insurance cost for high_value items, criteria, [sum_range])

The formula is therefore being copied and pasted down in the subsequent cells below to determine the values of other corresponding items.

Therefore, we can conclude that the excel formula to be used can be seen in the format outlined above.

Learn more about excel formulas here:

https://brainly.com/question/20620378?referrer=searchResults

Thanks for stopping by. We strive to provide the best answers for all your questions. See you again soon. Thanks for using our service. We're always here to provide accurate and up-to-date answers to all your queries. We're here to help at Westonci.ca. Keep visiting for the best answers to your questions.