Forum Discussion
Excel formule to check the charter invoice
JGA74 The attached workbook contains two possible solutions, depending on your Excel version. Note that I have changed the structure of the pricing tables a bit. See which solution suits you best.
- Thanks @Riny_van_Enkele,
That's exactly what I need. I just need one thing: for the price to be blank or equal to zero if the shipment status is also blank.
Because we don't pay for shipments that our system the status of the shipment isn't delivered.See the attached version (I only did the first solution; the alternative would work the same way)
Hi HansVogelaar
A question due to lack of knowledge... what means the "+1" in de formule? Why need to be de C6+1
=IF(F6="delivered"; INDEX(tblParcels;C6+1;MATCH(E6;tblParcels[#Headers];0))+(INDEX(tblPallets;D6+1;MATCH(E6;tblPallets[#Headers];0))); "")
This formula works. Thanks. I would like only to understand the +1.
(...)
On the second formula - one of the bill column gave me the message #N/A for some rows..
Is the " #N/A message" due to the fact that my company's data reference are not in the charter list?My work computer has Excel for Microsoft 365 MSO (version 2307)
