Answered

Discover the best answers at Westonci.ca, where experts share their insights and knowledge with you. Get quick and reliable answers to your questions from a dedicated community of professionals on our platform. Discover detailed answers to your questions from a wide network of experts on our comprehensive 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

Thank you for visiting. Our goal is to provide the most accurate answers for all your informational needs. Come back soon. Thanks for using our platform. We aim to provide accurate and up-to-date answers to all your queries. Come back soon. Westonci.ca is committed to providing accurate answers. Come back soon for more trustworthy information.