Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    May 2004
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula Help - Price = result (Excel97)

    Hello,

    can somebody point me in the right direction? I need to create a formula in a spreadsheet that will return a fee that the Local Government will charge me when I purchase a house. For instance, I enter the price of the property and it gives me the fee that I'll be charged. The brochure of the values is here http://www.reisa.com.au/pdf_files/Fees_July03.pdf .

    Kind regards,

    Marco

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formula Help - Price = result (Excel97)

    See if this works for you.

    I created 3 tables based on the info given. I had to add extra info in the conveyance table since the description did not match what the results were. This should give what the tabled values are.

    The are all VLOOKUP tables, looking up the info in the tables.

    Enter a value in Cell C15 and the 3 numbers are calculated. Look them over and if the calcs are unclear, post back.

    Steve
    PS Welcome to the Lounge

  3. #3
    New Lounger
    Join Date
    May 2004
    Location
    Australia
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Help - Price = result (Excel97)

    Hi Steve, thanks for the quick reply the other day.

    I've been experiencing mega problems with my login, so I do apologise for the time it has taken to respond! Fortunately the ever patient Claude was able to help out. The spreadsheet you posted works fabulous - now I just need to figure out how to do this sort of stuff myself! Time will tell....


    Once again, thank you so much for your help.

    Kind regards

    Marco

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formula Help - Price = result (Excel97)

    Happy to be of help.

    Steve

Posting Permissions

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