+ Reply to Thread
Results 1 to 4 of 4

Need to test for multiple variables in columns

  1. #1
    Registered User
    Join Date
    01-31-2007
    Posts
    2

    Need to test for multiple variables in columns

    I am checking whether certain buildings need to be demolished and rebuilt ('rebuild'), or whether they should be renovated ('Recap').

    The first key question I have to ask is "Is the building suitable for the occupants?" (The "yes" "no" answer is my first value).

    If the answer is Yes, even thought it is suitable, I ask if the cost to fix it is greater than the cost to replace it, in which case the building is rebuilt, otherwise it is recapped.

    If the answer is No, I ask if the cost to fix it is greater than 75% of the cost to replace it, in which case the building is rebuilt, otherwise it is recapped.

    The chart is easy, but I don't know how to program getting the right answer.

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Your first 2 criteria are pretty clear, but for the 3rd, are you asking how to use a formula to calculate the cost? Or how do you find the number of buildings that meet all 3 crieria? Or something else?

  3. #3
    Registered User
    Join Date
    01-31-2007
    Posts
    2
    If you have a look at the chart attachment, it shows that depending on the combination of YES's and NO's in specific columns, there are two possible actions:

    REBUILD or RECAP. I just want a formula that will generate those actions automatically in the last column.

    Does that make sense?

  4. #4
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Yes, that does make sense, but you didn't post your chart attachment.

+ 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