Forum Discussion
Generate Invoice Pricing - Multiple Criteria
Hi, In a bit of a rut picturing which formulas/processes would be best to use. Some background info: A consignment business which has a portfolio of cars for rent to the general public, by th...
TarrahLA Please find a quick-and-dirty solution in Sheet3, using the tables in Sheet2. The latter were converted to so-called Excel Tables. Only the shaded cells in Sheet3 require input. Daily fees are calculated based on the dates entered. Flat fees/add-ons have a quantity 1 (=Yes) or zero or empty (=No). The rest is automated. I hope it get you started into the right direction.
If you have the latest Excel on Office365, you can improve on the data validation and make it a bit more dynamic.
PS: You need to check the maths yourself. I may not have understood everything correct!