+ Reply to Thread
Results 1 to 3 of 3

Excel Novice - Please help

  1. #1
    Registered User
    Join Date
    04-30-2013
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Excel Novice - Please help

    Help me please! I am a complete excel novice, I work for an insurance broker in the UK and am looking to put together an excel spreadsheet that will help add together different scenarios in order to determine the correct premium to quote

    I already have the data that needs to be input but am having trouble putting it together on excel

    Example

    I am looking for multiple outcomes on a single excel cell i.e If I put the age of the driver into Cell B2 (say between 15-20) than cell B3 would than equal 2.3 again if I entered the age of the driver into B2 saying they where aged between 26-30 than B3 would than equal 3.4

    Eventually I would like to be able to multiply the answers to various questions separate I.e B3 X C3 + D3 = Premium I would quote

    I hope this makes sense, and I appreciate you taking the time to look at this post (Hope you can help)

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Excel Novice - Please help

    It's precisely the kind of thing excel does ...
    You need to create some lookup tables of age v premium etc and then use VLookup (or a variation) to recall the premium corresponding to the age group and any other criteria
    Elegant Simplicity............. Not Always

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Excel Novice - Please help

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1