Hi all,
i am in a spot of bother, i am working on an Expense sheet for work and our employees travel around a bit (internationally), i need to perform a calculation to give the VAT rate. what i have is a table of what country gives what VAT rate(have dummy data at the mo).in their expense sheet they have a colum for expense type and also what country, and with that info i need to be able to calculate in another colum, what rate it should be by getting it from the table.has anyone got any ideas? i have attached the table to show. i don't know of any lookup function that could do this,but maybe there is
thanks in adavnce
Shay
i am in a spot of bother, i am working on an Expense sheet for work and our employees travel around a bit (internationally), i need to perform a calculation to give the VAT rate. what i have is a table of what country gives what VAT rate(have dummy data at the mo).in their expense sheet they have a colum for expense type and also what country, and with that info i need to be able to calculate in another colum, what rate it should be by getting it from the table.has anyone got any ideas? i have attached the table to show. i don't know of any lookup function that could do this,but maybe there is
thanks in adavnce
Shay
Company Database.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
E | F | G | H | I | J | K | L | |||
67 | Chooseexpensetype | Ireland | GreatBritain | France | Holland | Japan | USA | |||
68 | Airtravel | 21% | 15% | |||||||
69 | CarJourney(owncar) | 15% | 12% | |||||||
70 | Carpark | 13% | 15% | |||||||
71 | CarTolls | 13% | 24% | |||||||
72 | TrainJourney | 13% | 15% | |||||||
73 | Taxi | 13% | 22% | |||||||
74 | Accommodation | 21% | 12% | |||||||
75 | Meal | 20% | 23% | |||||||
76 | Entertainment(nameclients) | 15% | 23% | |||||||
77 | Phone | 21% | 21% | |||||||
78 | MobilePhone | 13% | 12% | |||||||
79 | Other | 15% | 12% | |||||||
Monthly Expense |