In cell I7, insert an IF function with a nested AND function to determine shipping refunds. The AND function should ensure both conditions are met: Total Days is grater than Total Days Delivery Goal (cell C3) and Order Total is equal to or greater than Order Total Threshold (cell C2). If both conditions are met, the refund is 50% (cell C4) of the Shipping Cost. Otherwise, the refund is $0. Use mixed references as needed. In cell I7, insert an IF function with a nested AND function to determine shipping refunds. The AND function should ensure both conditions are met: Total Days is grater than Total Days Delivery Goal (cell C3) and Order Total is equal to or greater than Order Total Threshold (cell C2). If both conditions are met, the refund is 50% (cell C4) of the Shipping Cost. Otherwise, the refund is $0. Use mixed references as needed.

This is the image of data, chegg won't let me upload it.

https://gm1.ggpht.com/TZb6vV0TrBjiarApD1xMBYzlZdP9BzOLCYhl-mfvPLZSC8we9jbjjfrEd1eCMSib1Yb6JZphvWEAGeRwKN3FECYfZFhCJIrXYUd1Z-5RZSwVJbIe5j2oC7QMaVLsYt227CLwURyVS9mdwqRo91pQxISepDx24DkMTfpY5mmcFRO5-Wyn9dUhh4NwhO2jd_AoR7yPmzKDA-HCF52j7JkOlzS0KbMbDFJ-nNQL-IDsGgXTx88LsXEl1xdbuApcoZxDE8d7AdqYW_3y8tiCmMxY6m59_x3w0sG3YcVtxozObNFsysYRSs0PDshEdGGzFbqsP4i7RvtHFL_hlRFh_chdclgFJ3at4QvMIQLUljUpbyFubcs3FL3E6y0EVokRMNTxAfnNd3gSBtpV5q7t15Wi7SOVAntiO_qTGu9t_EoIS4K63-y_fWMUh-b2Vuvw_7QrqHDXnluXmxGJeftddHYh1WPadaEld7TE4jLYXlVWVCrdytd24vQ2mPU1b3EEIjoO9pdImduutJxaDZ8S5Gtd6HLNgRdp6AD0Q1jfWaSw888QN1FdFXW5qnwLLk7LB-h8fFK-PO-rLz9MOUN9EPxrNiKdlTcZ7VJ6bEyO4JLL-R4YFlSiaVOmXlyethus2jnQu8F1c9nLnN4_wmkVyF2JlDBZVr3cEtG-y_QS3aogVXwZ9bculHGraDEYOjuRoYwyjxE3QdnIvXiLGAnK7GfTElwxK17cdw3Di-b0JLpui9qFscNdYhwe2FOxDBK98PwdNHI=s0-l75-ft-l75-ft