Hello!!
I am trying to design a spreadsheet which will calculate which tariff is best to use for employees.
I have details of various tariffs and their peak/off peak charges, free peak/peak minutes and monthly cost, as well as monthly usage of employees...
I have started with one employee initially with all their usage on one worksheet and their charges on a second worksheet. I have done the calculations (by use of VLOOKUP and IF formulae) that when you select the tariff from the drop down box the charges are populated for that employee taking into account any free minutes on that tariff etc.
I now would like a little table to show the basic total of each individual tariff for the employee, as I will have to work out what's best and then factor in that if all employees are on the same network/tariff they would get a discount. Can Excel populate the table to show that when X Tariff is selected it totals Y and so on so as to do an easy comparison? Or any other suggestions would be useful?
thanks in advance
attached is an attempt to show a sample of what I am working with.... When selecting from the drop down A or B it calculates a total and I want to populate the various total results to compare the options.
p.s.Bob and Julie are pretend people..
Bookmarks