Answered

Get the answers you need at Westonci.ca, where our expert community is always ready to help with accurate information. Our platform provides a seamless experience for finding precise answers from a network of experienced professionals. Our platform provides a seamless experience for finding reliable answers from a network of experienced professionals.

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

We appreciate your visit. Hopefully, the answers you found were beneficial. Don't hesitate to come back for more information. Thanks for using our service. We're always here to provide accurate and up-to-date answers to all your queries. Thank you for trusting Westonci.ca. Don't forget to revisit us for more accurate and insightful answers.