Hi. Can anyone help with setting up excel please? Need to work out overcharges on invoices for client and they want to see what was charged each month v what should have been charged. Problem for my frazzled brain is they have a set price for twelve months and then reduced price for next 36 months, but each month they have an increase in number of outlets the charges are for. So contract price is say 75 outlets at £200 for 12months, in month 3 they add another 6 outlets , so original 75 are still on £200 charge, but the new outlets are just starting off their 12month period at £200. New outlets can be added each month, or sometimes just randomly. HELP.
