I am practically novice when it comes to Excel and I am looking for help.
In my new job we provide insurance premium quotes for customers which can be time consuming to find. The reason for this is each product belongs to a group number between 1 and 9.
We ask the product name so we can find the group number on 1 sheet of paper, and we then ask the value of the product so we can cross reference the group number with this value to find the premium and excess fee, please see below example of what I mean
Group <=1000 1001-1500 1501-2000 etc
1 32.00 35.00 39.00
2 33.00 37.00 40.00
etc
I would like to create a spreadsheet that saves us flicking through different pages of paper, like this:
Type the product name in: Product 1
Type the value of the product below: £1,456
Then with this information it would let us know the group number, premium and excess
Group Number: 1
Premium: £35.00
Excess: £25.00
Can some kind person with a lot of free time to spare, explain to me how I would go about setting something like this up?
Thanks in advance.
Bookmarks