+ Reply to Thread
Results 1 to 3 of 3

retirement plan

  1. #1
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,321

    retirement plan

    Iíd like a function,NOT macro, to calculate whether taking early retirement <60 but >55 is economically viable. Assuming the U.K. GNP is decreasing by 5% per annum, the RPI is increasing by 6% (forecast) and property prices are falling by 10% every 3 months. This to be based on my average annual salary + or -about 10 -15 hours a week overtime (Mondays to Friday @ X 1.3 sat and Sunday @ X 1.5. Please offset cost of private vehicle against public transport which can be calculated with convenience/time X comfort.
    This should all go into call H1 as a rating of X/10000 where the higher the X the better it will be for me. I expect to put salary in A1 and age in B2 and excel will calculate the rest. A look up will be required to determine what car I have from a list of 60 or so and give the rating of value based on Glassís guide. Obviously my salary will remain confidential but letís for calculation purposes put it in D1 and assume its >£1 and < £100,000.
    A graph (bar chart not acceptable) should appear whenever cell AZ6503 is selected
    Thanx in advance
    MDW

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,635


    In H1 and copy down, and down, and down: =IF(CanFly(Pigs), "Yes", "No")

    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,321
    very interesting and helpful sir,works exactly as stated.
    however just one further question porcine aviation not being in my (ever decreasing , i must admit)skill set .how would i change this formula to include a possible lottery win?

+ 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