Results 1 to 2 of 2

How to bring in the rent amounts here?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-21-2009
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    200

    How to bring in the rent amounts here?

    Please see attached pic.

    I've inserted notes in the workbook to make it easier to understand but I'll write out what I'm trying to do here as well.

    I have a number of stores and rents. A number of these have a chance of closing down this year. Some have a 50% chance, some 60%, etc. Some will close in Sept, some will close in Oct etc.

    I want to take the rents given on the left hand side of this worksheet, look at the chance of closing down, look at when it would close down, and use this to populate the right side of my worksheet.

    So for example if the rent for store A is $1000 and it has a 60% chance of closing in Oct, I'd want the new rent section to show $1000 in rent for the months from now til Sept, and then in Oct - Dec I'd want the rent to show as $600.

    How would I do this?
    Attached Images Attached Images
    Last edited by zazzz; 07-04-2016 at 04:40 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] HELP - This Macro works on small amounts of data but fails on large amounts
    By BookmanNLA in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-18-2015, 12:40 AM
  2. Array Formula Lookup - Bring back Lowest Date + Bring Back Cell Location
    By Matt1998 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2014, 12:08 PM
  3. Replies: 2
    Last Post: 02-23-2014, 09:56 PM
  4. [SOLVED] Add Invoice Amounts and Paid Amounts based on user inputs.
    By s2jrchoi in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-18-2013, 01:49 PM
  5. Formula to take amounts from other sheet with no duplicate amounts
    By Xx7 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-06-2013, 04:34 PM
  6. Replies: 2
    Last Post: 09-21-2012, 03:32 AM
  7. Replies: 1
    Last Post: 06-15-2010, 09:42 PM

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