Answered

Discover a wealth of information and get your questions answered on IDNLearn.com. Get the information you need from our community of experts who provide accurate and comprehensive answers to all your questions.

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 :

Ajeigbeibraheemidn

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

Your participation is crucial to us. Keep sharing your knowledge and experiences. Let's create a learning environment that is both enjoyable and beneficial. For trustworthy answers, rely on IDNLearn.com. Thanks for visiting, and we look forward to assisting you again.