+ Reply to Thread
Results 1 to 1 of 1

Math - current cost - cash received if sold

Hybrid View

  1. #1
    Registered User
    Join Date
    05-18-2009
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    34

    Math - current cost - cash received if sold

    Properties increase by 10% of the original price with each new purchase.

    Current Price:

    F37*(1+E37/10)
    Properties are built on a required property. If the required property has not been purchased, the Current Price is:

    IF(metropolis<2,VLOOKUP(metropolis,shipping_metropolis,2,FALSE)+F37*(1+E37/10),F37*(1+E37/10))
    If I sell this property, the Cash Received:

    E37*(G37+F37*0.9)/4
    However, it's incorrect if the required property is "not owned" in the spreadsheet. I need help figuring out the formula to exclude the price of the required property (the VLOOKUP) for the Cash Received.
    Last edited by emptycucumber; 05-22-2009 at 01:50 PM. Reason: NVM it was simple ... duh!

+ 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